VirtueMart Forum

VirtueMart 2 + 3 + 4 => General Questions => Topic started by: ptrouw on December 05, 2019, 13:36:47 PM

Title: Product filter extensions?
Post by: ptrouw on December 05, 2019, 13:36:47 PM
Hi,
We are using breakdesigns.net custom field filter extension. A great product but we are hitting some limits. Are there any other filter extensions on the market?
We are running into performance issues with a lot of filter options and a lot of products. Also the URL's are not SEO friendly.
Title: Re: Product filter extensions?
Post by: balai on December 05, 2019, 15:17:42 PM
Hi

The same functionalities in a lighter way cannot be found.
If you are looking for less functionalities, your current extension can become lighter. E.g. Simplify the queries to avoid parent/child products lookup, avoid counters, etc.
Or address to the developer to make it lighter.

But i suggest looking beyond the extension. There are several measures you can take in the server level, to avoid direct database queries.
To mention some:
Memcached (https://dev.mysql.com/doc/refman/5.6/en/ha-memcached-mysql-frontend.html)
Proxy SQL (https://proxysql.com/)
Query Caching (https://dev.mysql.com/doc/refman/5.7/en/query-cache.html)

or use an extension that caches your modules like JotCache (https://extensions.joomla.org/extension/jotcache/).
Title: Re: Product filter extensions?
Post by: Studio 42 on December 06, 2019, 01:39:55 AM
I have a tag extention, very light, using only primary keys(and can search for categories and manufacturers).
It load all by ajax, so no seo duplicates problem.
So it depend the filters. If you can send the live site URL, i can check if this meet your needs.
Title: Re: Product filter extensions?
Post by: GJC Web Design on December 06, 2019, 08:08:09 AM
QuoteI have a tag extention, very light, using only primary keys(and can search for categories and manufacturers).
It load all by ajax, so no seo duplicates problem.
So it depend the filters.

Have you an example Patrick as always looking for something faster/less load than BreakDesigns custom filters?
Title: Re: Product filter extensions?
Post by: Studio 42 on December 06, 2019, 11:13:56 AM
I dont know if the filter is always faster.
I only say that perhaps it can be more accurate for he's need. It's why i want more details.
Title: Re: Product filter extensions?
Post by: pinochico on December 11, 2019, 07:05:52 AM
For CustomFilters Pro PLS dont use core customfiled from VirtueMart, but TRY Customfieldforall from  breakdesign.

Why?

Customfiled from Virtuemart create index by Value of customfiled (String) not by ID in DB.

For this option we had the last year eshop with 220 000 products and 1400 filters and results is loaded cca 1-2 sec. (Eshop was connect online to SAP for stock info, then waiting little time :)