Speed and Navigation in very large VM site

[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]

reader with 0 post ?
Be a little serious.

[hellorain]

Hello,

We are ready to start.

Best Regards,
hellorain.

[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.

[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.