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
https://gist.github.com/weismannweb/8ad ... 8d751281b2
Ernie
My Github OC Site: https://github.com/IP-CAM
5'200 + FREE OC Extensions, on the World's largest private Github OC Repository Archive Site.
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.
the best tools ever created, to achieve full indexing as well as InnoDB switching.
Ernie
viewtopic.php?f=191&t=157984#p602699
My Github OC Site: https://github.com/IP-CAM
5'200 + FREE OC Extensions, on the World's largest private Github OC Repository Archive Site.
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.
No, it's not better than indexing, because indexing is much easier to commence and it GREATLY increases the speed of ALL queries while having zero side effects.
Professional OpenCart extensions, support and custom work.
Contact me via email or Skype by support@thekrotek.com
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.
You should think before you post.
Professional OpenCart extensions, support and custom work.
Contact me via email or Skype by support@thekrotek.com
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
I installed this:
"
Try this on first, to speed up Category Caching:
https://gist.github.com/weismannweb/8ad ... 8d751281b2
Ernie
"
-----------
And I made this:
"
This may solve your issue:
https://www.antropy.co.uk/blog/opencart ... very-slow/
"
When I did this one could not find those tables:
`oc_product_tag`
`oc_url_alias`
so I deleted then and moved on, but just 3 was successful the others ones show this "Note: #1831 Duplicate index" I think that was already indexed, in journal3 panel have a "Database Indexes" on performance tab.
So the search still take 10 seconds or more sadly....
This:
"
One could try, if ATOMIX famous DB Indexer still works with OC-3, it's one of
the best tools ever created, to achieve full indexing as well as InnoDB switching.
Ernie
viewtopic.php?f=191&t=157984#p602699 "
I did not try this because I don't think I have enough experience
Anyone have any suggestions ? Or I should put this in commercial support ?
Thanks again
Well, it does not require any experience, to upload a PHP File into the Shop Directory,I did not try this because I don't think I have enough experience
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'200 + FREE OC Extensions, on the World's largest private Github OC Repository Archive Site.
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 problemIP_CAM wrote: ↑Thu Apr 18, 2019 2:15 amWell, it does not require any experience, to upload a PHP File into the Shop Directory,I did not try this because I don't think I have enough experience
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
on gtmetrix.com, it's more like an esoteric discussion.
Ernie
My Github OC Site: https://github.com/IP-CAM
5'200 + FREE OC Extensions, on the World's largest private Github OC Repository Archive Site.
Thanks everyone, I'm sure the solutions you guys offered somehow helped me to speed up my site anyway
Users browsing this forum: No registered users and 45 guests