I have ocStore 3 and I tried to use this guide: http://octurbo.com/caching-opencarts-category-counts/
After that pagination disappeared and filters doesnt work. But I still can surf through pages adding ?page=XX and apply filters modifying link.
What can I do to make everything work fine?
That solution seems nice but it has no provision to replace the cache file in an expiration date or if data in the database changes and from what I can see actually slows things down.
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.
Professional OpenCart extensions, support and custom work.
Contact me via email or Skype by support@thekrotek.com
it is literally 90% copied from the equally named extension by pnsolsCopyright (C) 2011-2019 The Krotek. All Rights Reserved.
You can take that up with them.
Besides, for normal stores the overhead will vastly outweigh the benefits and the benefits are very limited.
Any query other than select,show tables or show columns will render the cache involving any of the tables referenced in that query obsolete.
Since OC updates the product table after every select to increase the product view count, almost any cache is immediately obsolete and as such this script is more busy writing and discarding caches than it is using them.
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.
He abandoned this extension and knows I got it from now. And actually it uses a 3rd party caching algorithm from the start.
I don't know what you call a "normal store", but it GREATLY increases the speed of highly loaded stores with lots of products and heavy themes.
Professional OpenCart extensions, support and custom work.
Contact me via email or Skype by support@thekrotek.com
Caches category data for Opencart 3.0 to make it faster
https://gist.github.com/weismannweb/8ad ... 8d751281b2
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.
and if you insist then just cache the entire menu structure in the common/menu controller with only language as variable.
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.
fair enough but if you want to continue to peddle this thing, either make provisions for:He abandoned this extension and knows I got it from now. And actually it uses a 3rd party caching algorithm from the start.
1) multi byte character support which it does not have and causes errors
2) most importantly cater for the fact that OC updates the view count in the product table on every product request rendering the caches useless.
or at least mention these issues.
With those solved it could actually be a good one, for high traffic sites that is.
Ideally OC should have never put that field in the product table as it currently also renders any mysql query cache referencing the product table useless.
Taking that field out into a separate table is easy and necessary.
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.
Or, since the parent categories are already dependable on the main categories to optimize the category table, to simply regroup the category counts by cat parent cache or by visible cat cache.Taking that field out into a separate table is easy and necessary.
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
The fact that OC updates that field every time a product if viewed and as such the product table, renders "his" db cache extension rather useless as well as any mysql query cache as they are flushed with an update.
So my point was to move that field into a separate table so that the product table is not updated every view with this useless field and thus the caches extension-wise or mysql-wise become relevant and useful again.
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.
Users browsing this forum: Bing [Bot] and 532 guests