Saltar navegación

[Resuelto] View with 17,000 entries

This support ticket is created hace 1 mes, 1 semana. 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.

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

Supporter timezone: Asia/Kolkata (GMT+05:30)

Este tema contiene 1 respuesta, tiene 1 mensaje.

Última actualización por Minesh hace 1 mes, 1 semana.

Asistido por: Minesh.

Autor
Mensajes
#2806023
query.jpg

Hi, I've a CPT with 17,000 entries. I've built a view with pagination (15 entries poer page) ordered by title and with custom search by text search and a custom taxonomy.

The website is very slow, IQuery Monitor show that the view is loading all the 17,000 IDs before the view display.

How can I optimize it?

thanks

#2806176

Minesh
Colaborador

Idiomas: Inglés (English )

Zona horaria: Asia/Kolkata (GMT+05:30)

Hello. Thank you for contacting the Toolset support.

The screenshot you shared is for the postmeta cache.

You should check the original view query and see if it query the 15 entries as you set the pagination per per or it loads all 17000 posts.

You can enable the views debug and check the Query generated by view:
- https://toolset.com/documentation/programmer-reference/debugging-sites-built-with-toolset/#the-views-debug-tool