Skip Navigation

[Resolved] View with 17,000 entries

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)

This topic contains 1 reply, has 1 voice.

Last updated by Minesh 1 week, 2 days ago.

Assisted by: Minesh.

Author
Posts
#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
Supporter

Languages: English (English )

Timezone: 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