Skip Navigation

[Resolved] Views taxonomy cache very slow

This support ticket is created 3 years, 9 months ago. There's a good chance that you are reading advice that it now obsolete.

This is the technical support forum for Toolset - a suite of plugins for developing WordPress sites without writing PHP.

Everyone can read this forum, but only Toolset clients can post in it. Toolset support works 6 days per week, 19 hours per day.

No supporters are available to work today on Toolset forum. Feel free to create tickets and we will handle it as soon as we are online. Thank you for your understanding.

Sun Mon Tue Wed Thu Fri Sat
- 9:00 – 12:00 9:00 – 12:00 9:00 – 12:00 9:00 – 12:00 9:00 – 12:00 -
- 13:00 – 18:00 13:00 – 18:00 13:00 – 18:00 14:00 – 18:00 13:00 – 18:00 -

Supporter timezone: America/Jamaica (GMT-05:00)

Tagged: 

This topic contains 7 replies, has 2 voices.

Last updated by Shane 3 years, 9 months ago.

Assisted by: Shane.

Author
Posts
#1691599
2020-07-08_14-42-53.png
2020-07-08_14-41-40.png

Hello,

While analyzing performance issues using XDebug profiling I noticed that Views needs very long to build up the taxonamy cache.

It seems, that it is loading and processing every single term from the database.

Thanks,

Adrian

#1692097

Shane
Supporter

Languages: English (English )

Timezone: America/Jamaica (GMT-05:00)

Hi Adrian,

Thank you for getting in touch.

We are constantly improving our Views/Blocks plugin so that it can run faster and smoother for our customers.

Can you let me know what kind of view is this ? Also does this only occur when you first load the view up ?

Please let me know.

Thanks,
Shane

#1692449
2020-07-09_08-52-07.png

Hello Shane,

The view is a search view with filters.

This seems to happen on every request. At least in my profiling.

All other caches are fast, only terms.

#1703031

Shane
Supporter

Languages: English (English )

Timezone: America/Jamaica (GMT-05:00)

Hi Adrian,

Thank you for the information. I assume that this is normal for now, however our team is constantly working to improve this functionality.

I also believe that this could be due to the setting on a view where you can only allow the view to show options that will produce a result.

Do you have this option enabled? Also are you experiencing any slowdowns of the site on the frontend itself ?

Please let me know.
Thanks,
Shane

#1704811

Hello Shane,

Thank you.

Yes we have "Show only available options for each input" enabled, disabling this options really improves page loading times.
I will speak to my client, if this would be an option.

Edit: A good tradeoff would be to enable/disable this on a per-filter basis. I.e. we have 10+ taxonomies, but only would need about 2 or 3 to be already prefiltered

Thanks,

Adrian

#1705435

Shane
Supporter

Languages: English (English )

Timezone: America/Jamaica (GMT-05:00)

Hi Adrian,

With the "Show only available options for each input" live queries are done to ensure that only the options that will produce a result will be available. This can have a speed impact as you can imagine you will need to pull all the items and check the post database in order to return only those options.

Hopefully your client will agree to have this option disabled. There will be some tradeoffs as the "Show only available options for each input" is far more complex than just leaving it disabled.

Please let me know as soon as possible.

Thanks,
Shane

#1714581

Hello Shane

We disabled the option for now.
Not a real solution, but a valid workaround for us.

Thanks,

Adrian

#1716133

Shane
Supporter

Languages: English (English )

Timezone: America/Jamaica (GMT-05:00)

Hi Adrian,

Thank you for the update on this one.

If there are no further queries you may go ahead and close this ticket when ready.

Thanks,
Shane

This ticket is now closed. If you're a WPML client and need related help, please open a new support ticket.