News:

Looking for documentation? Take a look on our wiki

Main Menu

Speed and Navigation in very large VM site

Started by behemoth, April 05, 2019, 09:58:01 AM

Previous topic - Next topic

behemoth

VM is currently 3.4 but ideally we want an extension that is supported by the widest possible selection of versions for future-proofing.

We have a site with currently 1.8 million products, but due to the nature of our business this is set to grow - slowly but indefinitely.

Both site search and product filtering are incredibly slow (in the order of tens of seconds) and clearly this not acceptable for customers. I've done a lot of work on the front end and I'm getting reasonable pagespeed scores for specific metrics, but the backend / database is clearly the bottleneck.

We've had some good results implementing an ElasticSearch component to handle site search, but the results it returns can't be filtered.

I'm currently testing implementing varnish cache, and while it performs fantastically for cached pages, it doesn't help uncached ones and logged in users don't see cached pages. It's also a massive job (perhaps impossible?) to try to warm a cache of that size.

I can provide a more detailed specification if you're interested in the job.

haydenmellins

Hi @behemoth,

Hope you are doing well.

I sent you PM. Please revert back to me for further discussion.

Regards,
Hayden  :)

Studio 42


hellorain

Hello,

We are ready to start.

Best Regards,
hellorain.
Raincreatives - Virtuemart & Mobile Commerce Experts

JoomlaGeek.com

Hello,

You can use our Geek ElasticSearch component, it supports VirtueMart and many other 3rd party extensions.
https://www.joomlageek.com/product/component-geek-elasticsearch

You can checkout demo for VirtueMart search and filters here
http://elasticsearch.demo.joomlageek.com/virtuemart-filters

Studio 42

demo with 1200 products only ? You should do a demo with 100 000 products or more, so we can verify the speed.
And how big is the server ?

JoomlaGeek.com

Hello,

You can test the website below of our client, it has more than one million products, and the search + filters works very fast
https://www.azeeda.com/search

pinochico

We use geekelasticsearch on cosmetic website with 45000 products.

They was very quickly, but every month we must pay to amazon for special DB server 100-200 USD.
And view for result was not as we need (we must develop custom view with a lot of hours...)

Then I stop use this solution after 4 months.

This year we creating new own solution together with Rupostel with Free DB.
www.minijoomla.org  - new portal for Joomla!, Virtuemart and other extensions
XML Easy Feeder - feeds for FB, GMC,.. from products, categories, orders, users, articles, acymailing subscribers and database table
Virtuemart Email Manager - customs email templates
Import products for Virtuemart - from CSV and XML
Rich Snippets - Google Structured Data
VirtueMart Products Extended - Slider with products, show Others bought, Products by CF ID and others filtering products

JoomlaGeek.com

Hello Pinochico,

You can download Elasticsearch on its official website and install it on your server, it is totally free
https://www.elastic.co/downloads/elasticsearch

So you don't have to pay monthly fees for cloud search providers.