[SOLVED] Search very slow to show products

Post by carollz » Tue Apr 16, 2019 9:24 pm

Hello,

I have a 3.0.3.2 opencart version I use Journal 3 and Lightning module. Have about 13.000 products and my search take about 7-20 seconds to show the products after I press "enter" I looked for extensions but all just do "live ajax search" and seems not improve the search time, there is a easy way to speed it up or you guys know a extension that will for sure speed the search loading time ?

My store its in maintence mode but I can take off so you guy can try it, just let me know

This is killing me, with lightning the product page open in less than 1second and the search takes 20 seconds to show....

Thanks for your time

Post by IP_CAM » Tue Apr 16, 2019 10:23 pm

My Github OC Site: https://github.com/IP-CAM
5'600 + FREE OC Extensions, on the World's largest private Github OC Repository Archive Site.

Post by letxobnav » Tue Apr 16, 2019 10:38 pm

Crystal Light Centrum Taiwan
Extensions: MailQueue | SUKHR | VBoces

“Data security is paramount at [...], and we are committed to protecting the privacy of anyone who is associated with our [...]. We’ve made a lot of improvements and will continue to make them.”
When you know your life savings are gone.

Post by IP_CAM » Tue Apr 16, 2019 10:45 pm

My Github OC Site: https://github.com/IP-CAM
5'600 + FREE OC Extensions, on the World's largest private Github OC Repository Archive Site.

Post by letxobnav » Wed Apr 17, 2019 11:36 am

Crystal Light Centrum Taiwan
Extensions: MailQueue | SUKHR | VBoces

“Data security is paramount at [...], and we are committed to protecting the privacy of anyone who is associated with our [...]. We’ve made a lot of improvements and will continue to make them.”
When you know your life savings are gone.

Post by thekrotek » Wed Apr 17, 2019 1:21 pm

Professional OpenCart extensions, support and custom work.
Contact me via email or Skype by support@thekrotek.com

Post by letxobnav » Wed Apr 17, 2019 1:50 pm

Crystal Light Centrum Taiwan
Extensions: MailQueue | SUKHR | VBoces

“Data security is paramount at [...], and we are committed to protecting the privacy of anyone who is associated with our [...]. We’ve made a lot of improvements and will continue to make them.”
When you know your life savings are gone.

Post by thekrotek » Wed Apr 17, 2019 2:00 pm

Professional OpenCart extensions, support and custom work.
Contact me via email or Skype by support@thekrotek.com

Post by paulfeakins » Wed Apr 17, 2019 5:27 pm

Now now, please play nicely

This may solve your issue:
https://www.antropy.co.uk/blog/opencart ... very-slow/

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

Post by carollz » Wed Apr 17, 2019 8:20 pm

Post by IP_CAM » Thu Apr 18, 2019 2:15 am

I did not try this because I don't think I have enough experience

Well, it does not require any experience, to upload a PHP File into the Shop Directory,
call it by it's name in the browser, and then click one button first, and then the other
one, after the first button has been doing it's job.

But I really wonder, that not one of the Dev's found some free time yet, to confirm,
that it works with latest Version OC ...
Ernie

My Github OC Site: https://github.com/IP-CAM
5'600 + FREE OC Extensions, on the World's largest private Github OC Repository Archive Site.

Post by carollz » Thu Apr 18, 2019 2:43 am

IP_CAM wrote: ↑

Thu Apr 18, 2019 2:15 am

I did not try this because I don't think I have enough experience

Well, it does not require any experience, to upload a PHP File into the Shop Directory,
call it by it's name in the browser, and then click one button first, and then the other
one, after the first button has been doing it's job.

But I really wonder, that not one of the Dev's found some free time yet, to confirm,
that it works with latest Version OC ...
Ernie

I did this now, show the page and apparently was successful, but sadly the slow continues, and not just the search, the filters and change category pages its very slow too, all three situations takes 10 ~20 seconds to show results, I think this is a more complex problem

Post by IP_CAM » Thu Apr 18, 2019 3:03 am

Well, as long as no-one can find out, i.E., by checking your Site
on gtmetrix.com, it's more like an esoteric discussion.
Ernie

My Github OC Site: https://github.com/IP-CAM
5'600 + FREE OC Extensions, on the World's largest private Github OC Repository Archive Site.

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

Hello everyone, the problem was with journal filter and iWatermark, on lightning extension show the diagnosis of every pages, and each one took about 3 seconds to run and a total of 6500 Real queries once I disable the watermark module and journal filter the search show the results in 2 seconds and the number dropped to 60 Real queries! I will contat the isense labs for a solution for watermark extension and I will look for another filter module, you guys recommend one ?

Thanks everyone, I'm sure the solutions you guys offered somehow helped me to speed up my site anyway

Post by nikos155 » Tue Jun 23, 2020 1:33 am

Post by nikos155 » Tue Jun 23, 2020 1:33 am