Search Results and Change Category Page VERY slow

Post by carollz » Thu Apr 18, 2019 12:56 am

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

Post by JAY6390 » Thu Apr 18, 2019 5:09 am

Post by gabriel.albert » Thu Apr 18, 2019 1:07 pm

Post by ostechnologies » Thu Apr 18, 2019 2:28 pm

Opencart Expert | sales[at]ost.agency
Skype - manish.osuniverse | Gtalk - manishmt

Extensions for Opencart @ https://www.ost.agency/product/product- ... extensions
ost.agency - ecommerce website design, development and digital company

Post by deepvyas » Thu Apr 18, 2019 5:06 pm

Expert Opencart Developer & Designer | S: deepvyas71 | E: deepvyas71@gmail.com

Post by paulfeakins » Thu Apr 18, 2019 5:11 pm

UK OpenCart Hosting | OpenCart Audits | OpenCart Support - please email info@antropy.co.uk

Post by carollz » Fri Apr 19, 2019 12:21 am

Post by finbos » Sun Apr 26, 2020 1:41 am

Post by finbos » Sun Apr 26, 2020 1:43 am