Hi Guys,
I have moved my store to the new version from 1.5.6 to 3.0.3.1. I did the change to improve several things. In general loading speed is not that bad of the home page however when you move to subcategory and you will jump from one page to another it takes like 20 seconds plus to load the page. I am using the Nitropack module, it didn't help that much. I don't know what I can do to improve this speed... I will really appreciate any help or advice from the experts on this forum. It is a painful process for my customers to choose the products. I have also moved to a new hosting provider but this issue still persists.
Best regards,
Sebastian
Nitropack is absolutely useless and only messes with the system. I'd recommend you to remove it completely.
As for your speed issues, the reasons vary, but mostly it's about database indexing and your number of products/categories. Other reasons are possible as well, but they must be addressed personally. I can look into your issue myself, I optimized a lot of stores and made their owners happy. Drop me an email, if interested.
As for your speed issues, the reasons vary, but mostly it's about database indexing and your number of products/categories. Other reasons are possible as well, but they must be addressed personally. I can look into your issue myself, I optimized a lot of stores and made their owners happy. Drop me an email, if interested.
Professional OpenCart extensions, support and custom work.
Contact me via email or Skype by support@thekrotek.com
Hello Thekrotek,
Thank you for your reply. Is there anything else that I can do on the opencart settings such as "counting" products feature or anything else which can help?
I am using OXY template but I dont think so that this can change the speed of the subcategories...
Best regards,
Sebastian
Thank you for your reply. Is there anything else that I can do on the opencart settings such as "counting" products feature or anything else which can help?
I am using OXY template but I dont think so that this can change the speed of the subcategories...
Best regards,
Sebastian
I'm not sure I understand your question and how "counting products" will help you solve the issue.
Professional OpenCart extensions, support and custom work.
Contact me via email or Skype by support@thekrotek.com
Cache Category Product Counting OC v.3.x:
https://gist.github.com/weismannweb/8ad ... 8d751281b2
https://gist.github.com/weismannweb/8ad ... 8d751281b2
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.
Why use this, when you can speed up your whole store using Database Cache?IP_CAM wrote: ↑Fri Apr 26, 2019 3:27 amCache Category Product Counting OC v.3.x:
https://gist.github.com/weismannweb/8ad ... 8d751281b2
Professional OpenCart extensions, support and custom work.
Contact me via email or Skype by support@thekrotek.com
Well, DB Caching made no difference to me, by comparing it on
GtMetrix so far, but I possibly overlooked something, and I'm
presently working on that 'last' matter anyway ...
Ernie
GtMetrix so far, but I possibly overlooked something, and I'm
presently working on that 'last' matter anyway ...
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.
It helps A LOT, when you have thousands of products. When you have a few dozen or a hundred, you don't need any DB caching.
Professional OpenCart extensions, support and custom work.
Contact me via email or Skype by support@thekrotek.com
it uses unserialize() which does not go well with multi-byte character sets.
if it were using json_encode/decode then it would be an option.
if it were using json_encode/decode then it would be an option.
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.
Works quite well, no complaints at all.
Professional OpenCart extensions, support and custom work.
Contact me via email or Skype by support@thekrotek.com
well, I think it is a great mod, I am sure it work perfect for single byte character sets and surely will speed things up even with few products.
(the # of products is rarely the issue, it are the options, filters, categories etc. and the fact that OC indeed executes the same queries over and over which slow things down)
But with mb it will start producing "PHP Notice: unserialize(): Error at offset" errors and render the cachemap corrupt.
Trust me, my main language is traditional chinese, I know.
(the # of products is rarely the issue, it are the options, filters, categories etc. and the fact that OC indeed executes the same queries over and over which slow things down)
But with mb it will start producing "PHP Notice: unserialize(): Error at offset" errors and render the cachemap corrupt.
Trust me, my main language is traditional chinese, I know.
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.
Why use this OC extension instead of https://proxysql.com ?thekrotek wrote: ↑Fri Apr 26, 2019 3:39 amWhy use this, when you can speed up your whole store using Database Cache?IP_CAM wrote: ↑Fri Apr 26, 2019 3:27 amCache Category Product Counting OC v.3.x:
https://gist.github.com/weismannweb/8ad ... 8d751281b2
Jim
https://www.carguygarage.com
Yahoo Store since 2006 moved to OpenCart on January 24, 2020
Well, let me first explain: From my personal point of View, the Product - ListingWhy use this OC extension instead of https: //...
Pages belong to the most important files, to be cached, because Visitors don't
want to spend surplus time on such Pages, but find, what they're looking for,
and that without delay ...
And in my opinion, Product Quantities are highly important for many, to show
Visitors, if an item is available, and in what Quantities. They should exist, but
their 'default-design' slows down overall Page Load in considerable amounts.
A Category Page Product Cache Mod caches the 'Quantity' of each Product,
so, there is absolutely no need, to call the Database, just to get those Values,
in xx times repeated form, if a Copy of every Value exists in a Cache
Directory File on the Server instead. One should only 'contact' a Master MySql
Database, if there is no easy way around it, better keep that in your mind !
http://www.velomech.ch/shop/Desktops-c20.html
---
It's a different story, when it comes to DB Cache Files, in this case the one,
created by PN Solutions. It stores a lot of Code, troughout the entire Database,
to have it 'present' on the Server as simple Flatfile type Database Code. Kind of
at least, it's hard to explain, for someone not of english origin...
I added an image to let you see parts of such a DB Cache File Content:
download/file.php?mode=view&id=36904
---
STILL, it's faster, to look for something specific like a Product Qty- Value, by placing
such Code in it's own File, even compared with browsing trough a valuable Amount of
an also busy DB Cache File data, just to find simple Product Qty-values.
---
I also made some Category Performance Tests, since I usually only have
~3'000 auto-generated Products online in my Test Shops. The first Test
was with 10'000 Products, and the second Test with 20'000 different items,
with and without PN SOL's DB Caching. It had no influence whatsoever, both
turned out to act about the same:
download/file.php?mode=view&id=36903
---
But that's only valid for Product Counting, and the important Role it plays,
if not 'handled' with Care!
And I cannot judge, since I also use the DB-Cachefor the first time for real as well. But I use a variety of other small Modifications,
in order to get a decent GTMetrix Rating, just be aware ot that too.
And it's not done, by aquiring an Extension only, but takes a little work, reading,
and testing, to eventually end up as expected.
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.
I would strongly disagree I'm afraid. iSense are very good developers, the extension works very well and they provide great support.
However, I suspect your issue is this:
viewtopic.php?t=165423
UK OpenCart Hosting | OpenCart Audits | OpenCart Support - please email info@antropy.co.uk
Legendary Member
that may be so but I do not like extensions which call home.
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.
@thekrotek
one thing I would alter in your query cache mod is the exclusion of the product viewed update or at least give that option.
Now, it removes the entire product query directly after it inserts it because OC updates the product table every time to increase the view count.
This is of course how it should be as the product table is modified which makes select queries involving the product table obsolete but it also renders the caching of the product query useless and only adds the overhead of adding and removing that query and any other query related to the products table just for that stupid viewed field. And that is a shame.
one thing I would alter in your query cache mod is the exclusion of the product viewed update or at least give that option.
Now, it removes the entire product query directly after it inserts it because OC updates the product table every time to increase the view count.
This is of course how it should be as the product table is modified which makes select queries involving the product table obsolete but it also renders the caching of the product query useless and only adds the overhead of adding and removing that query and any other query related to the products table just for that stupid viewed field. And that is a shame.
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.
But they need to protect their investment of developer hours in a high quality product, for me it is acceptable.
UK OpenCart Hosting | OpenCart Audits | OpenCart Support - please email info@antropy.co.uk
Legendary Member
How does that protect their investment?
Besides, I was referring to the free version.
Least they could do is mention they are doing it and what data is exchanged.
Besides, I was referring to the free version.
Least they could do is mention they are doing it and what data is exchanged.
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.
They check for a license key.
Free version of Nitropack Cache? Is there one?
What data *is* being exchanged?
UK OpenCart Hosting | OpenCart Audits | OpenCart Support - please email info@antropy.co.uk
Legendary Member
Well, there is one, as it looks! Or something like it at least ...Free version of Nitropack Cache? Is there one?
NitroPack IO - Performance & SEO Booster
https://www.opencart.com/index.php?rout ... n_id=36373
Lucky me, that I don't need it, since it is not available for my oldie ...
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.
Who is online
Users browsing this forum: Bing [Bot] and 28 guests
