Page 1 of 1

Search Results and Change Category Page VERY slow

Posted: Thu Apr 18, 2019 12:56 am
by carollz
Hello,

I have a 3.0.3.1 store, I use Journal 3, Lightning and iSearch Corporate.

I made the index manually of database (https://www.antropy.co.uk/blog/opencart ... very-slow/) but my search takes 10-20 seconds to show the products after I hit "enter".... and in category pages take about 8 - 15 seconds to load the other page, admin side super fast, with lightning product and category page really fast, just change the category page, using filter and search takes about 10-20 seconds to show the results.

I really want to solve this, my website it almost done but this is killing me....

I have 13k products I don't think I have a big database.. and its VPS dedicade server with 800gb ssd, 30gb memory ram and 8 cpu

So what I want is:

Make the search fast
Make the transitions on categorys page fast
Make the filter resultes show fast

I think this problem its linked and I really hope to find a solution :(

Re: Search Results and Change Category Page VERY slow

Posted: Thu Apr 18, 2019 5:09 am
by JAY6390
PM Sent

Re: Search Results and Change Category Page VERY slow

Posted: Thu Apr 18, 2019 1:07 pm
by gabriel.albert
Hi Caroliz,,
Greetings for the day !!

I have checked your given requirement and would be happy to help. Please mail me at: gabriel.cisin20@gmail.com and add me on skype: gabriel@cisinlabs.com to discuss more.

Looking forward to hearing you soon.

Regards
Gabriel A.
M: +1-347-960-4171

Re: Search Results and Change Category Page VERY slow

Posted: Thu Apr 18, 2019 2:28 pm
by ostechnologies
Hello,

We can help you. You can contacts us at manish@ost.agency

Re: Search Results and Change Category Page VERY slow

Posted: Thu Apr 18, 2019 5:06 pm
by deepvyas
Hi ,
Greetings !
I can assist you further on search taking time.
Please contact - deepvyas71@gmail.com

Regards
Deep

Re: Search Results and Change Category Page VERY slow

Posted: Thu Apr 18, 2019 5:11 pm
by paulfeakins
Hi there,

We should be able to help with this, would you be able to drop us an email to get an estimate?
info@antropy.co.uk

Kind regards,
Alex
www.antropy.co.uk

Re: Search Results and Change Category Page VERY slow

Posted: Fri Apr 19, 2019 12:21 am
by carollz
Thanks everyone I was able to solve this by myself, so I don't need the support anymore, but thanks for your time!

Re: Search Results and Change Category Page VERY slow

Posted: Sun Apr 26, 2020 1:41 am
by finbos
Hi, @carollz if you can specify how you fixed the issue, it would be very helpful.
Thanks

Re: Search Results and Change Category Page VERY slow

Posted: Sun Apr 26, 2020 1:43 am
by finbos
carollz wrote:
Fri Apr 19, 2019 12:21 am
Thanks everyone I was able to solve this by myself, so I don't need the support anymore, but thanks for your time!
If you can specify how you resolved it, it would be very helpful for everyone that is having the same issue.
Thanks