Search Results and Change Category Page VERY slow

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

PM Sent

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

Hello,

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

Hi ,
Greetings !
I can assist you further on search taking time.
Please contact - deepvyas71@gmail.com

Regards
Deep

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

Thanks everyone I was able to solve this by myself, so I don't need the support anymore, but thanks for your time!

Hi, @carollz if you can specify how you fixed the issue, it would be very helpful.
Thanks

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