Hi all,
I'd appreciate it if you could give me some feedback about scale.
Can anyone here share info on the largest known VM shop? How many products & categories are the most you've seen in a VM shop?
I've never worked on a VM shop with more that 10.000 products. Would you recommend it for a large-scale ecommerce site with 50.000 ~ 80.000 products and medium-to-high traffic?
the largest install I have worked on was a car parts site
migrated from VM1.1 to VM3
100,000 products
370,000 custom fields
around 15,000 categories
the .sql dump was 178MB :o
worked fine - but had a decent VPS server
100K products in 15K categories? :o Wow!
Do you know the approximate number of orders per day?
Thanks,
Alex
A customer run a site with 10000 products, 5000 categories with near 1000 unique user per day on a 5€ shared server .
html render in 300ms and page load in 1 second.
Of course this depend how you use Virtuemart(children,customfields...), optimisations and other thing.
so I think we can say there is no real upper limit on products etc
and concurrent visitor handling depends on your server strength ( and of course site optimisations)
Thanks guys!
At such a large scale (100K prods), do you prefer to stick with the core cache capabilities and maybe tweak them, or do you opt for a caching extension?
it isn't an issue .. even though there's 100K of products your not with normal access querying them all -- you render the first 20 etc .. what ever your pagination is
obviously searching or filtering will be a much higher load but what can u do? You can't cache searches
You build your website with best practice to produce as fast a website possible --
No shitty overloaded eye candy templates etc etc
Quote from: GJC Web Design on December 14, 2018, 10:29:58 AM
No shitty overloaded eye candy templates etc etc
Totally agree, I always build a custom template for each project (as clean & minimal as the client will allow -clients love bling :P) to avoid a bloated front end.
If you have plenty of categorie i wrote a category module using a static cache (that can be cleared using Joomla cache clear).
It only use 2 queries first time so it's from 2x to 100x faster(no, this are not fake statistics) see https://shop.st42.fr/en/categories-tools/virtuemart-categories-menu.htm
Quote from: Studio 42 on December 14, 2018, 12:14:12 PM
If you have plenty of categorie i wrote a category module using a static cache (that can be cleared using Joomla cache clear).
It only use 2 queries first time so it's from 2x to 100x faster(no, this are not fake statistics) see https://shop.st42.fr/en/categories-tools/virtuemart-categories-menu.htm
Nice! I'll give it a try soon :)