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!