How to speed up product filtering?

[ad_1]

I have a multivendor store (Dokan) with over 1500 products that all have a variety of attributes and variations.

I have an AJAX filter on my shop page that works decently well for filtering products, but tiny gods is it slow!

Any suggestions on speeding this up?

[ad_2]
1 Comment
  1. That honestly doesn’t sound like that many records to filter. Maybe the query is complex enough that it’s really justified for the ajax query to take a noticeable amount of time. Or it could be your filter is poorly coded and the DB is poorly indexed? You need to find someone with time take a close look at your site, code and db.

    If you’re super serious about optimizing, and if the total payload to send the entire 1500 records isn’t too big, it might be possible to achieve the best speeds by doing the filtering entirely in JS on the client. However, this is likely going to be a more significant undertaking, and you might be happy enough just identifying the problem with your existing setup.

 

This site will teach you how to build a WordPress website for beginners. We will cover everything from installing WordPress to adding pages, posts, and images to your site. You will learn how to customize your site with themes and plugins, as well as how to market your site online.

Buy WordPress Transfer