Slow performance with depth filter on larger site

Created on 27 March 2023, over 1 year ago

Problem/Motivation

I am using the module on larger ecommerce site. I use it to display products on taxonomy pages which are shop categories. After import of larger catalog (about 30000 products) I noticed that category pages are very slow. At least for the first load. After caching it's quite fine.
But for first time load it can take more that 5 seconds to load.
This slow performance is only when using with depth option. So when I want to show products which belongs to current category and all subcategories. When I disable depth option and only display products from current category the performance is fine

Steps to reproduce

Create view and apply contextual filter to display only entities belonging to taxonomy term with depth.

Proposed resolution

I don't know if there is some option to optimise query but it would be very welcomed.

πŸ› Bug report
Status

Postponed: needs info

Version

1.14

Component

Code

Created by

Live updates comments and jobs are added and updated live.
Sign in to follow issues

Comments & Activities

  • Issue created by @sakonn
  • Status changed to Postponed: needs info over 1 year ago
  • πŸ‡¦πŸ‡ΊAustralia larowlan πŸ‡¦πŸ‡ΊπŸ.au GMT+10

    @sakonn thanks for taking the time to report this.

    Are you able to get a copy of the query from e.g. the views preview with SQL debugging turned on from the views settings?

    If so, can you provide an explain for it?

Production build 0.71.5 2024