Virtuemart -how high can it fly?

[dslove]

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?

[GJC Web Design]

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 

worked fine - but had a decent VPS server

[dslove]

100K products in 15K categories? Wow!

Do you know the approximate number of orders per day?

Thanks,
Alex

[Studio 42]

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.

[GJC Web Design]

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)

[dslove]

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?

[GJC Web Design]

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

[dslove]

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 ) to avoid a bloated front end.

[Studio 42]

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

[dslove]

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