News:

Support the VirtueMart project and become a member

Main Menu

Virtuemart -how high can it fly?

Started by dslove, December 13, 2018, 18:14:22 PM

Previous topic - Next topic

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  :o

worked fine - but had a decent VPS server

GJC Web Design
VirtueMart and Joomla Developers - php developers https://www.gjcwebdesign.com
VM4 AusPost Shipping Plugin - e-go Shipping Plugin - VM4 Postcode Shipping Plugin - Radius Shipping Plugin - VM4 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
https://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

dslove

100K products in 15K categories? :o 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)
GJC Web Design
VirtueMart and Joomla Developers - php developers https://www.gjcwebdesign.com
VM4 AusPost Shipping Plugin - e-go Shipping Plugin - VM4 Postcode Shipping Plugin - Radius Shipping Plugin - VM4 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
https://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

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
GJC Web Design
VirtueMart and Joomla Developers - php developers https://www.gjcwebdesign.com
VM4 AusPost Shipping Plugin - e-go Shipping Plugin - VM4 Postcode Shipping Plugin - Radius Shipping Plugin - VM4 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
https://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

dslove

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.

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

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 :)