Skip Navigation

Home › Support › English Support › [Closed] Thousands of DB queries when listing pages / post types in admin area

[Closed] Thousands of DB queries when listing pages / post types in admin area

This is the technical support forum for WPML - the multilingual WordPress plugin.

Everyone can read, but only WPML clients can post here. WPML team is replying on the forum 6 days per week, 22 hours per day.

Sun Mon Tue Wed Thu Fri Sat
- 9:00 – 13:00 9:00 – 13:00 9:00 – 13:00 9:00 – 13:00 9: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: America/Los_Angeles (GMT-08:00)

Tagged: 

This topic contains 1 reply, has 2 voices.

Last updated by Bobby 3 weeks, 6 days ago.

Assisted by: Bobby.

Author Posts
October 16, 2024 at 2:04 pm #16296108

lukeT-2

Background of the issue:
I am trying to list custom post types, posts, and pages in the admin area of WordPress.

Symptoms:
I experienced a load time of 3 seconds and over 3000 database queries when WPML is active. When WPML is deactivated, the load time drops to 0.8 seconds with 300 database queries.

Questions:
Why does WPML cause a high number of database queries?
How can I reduce the load time when WPML is active?
October 16, 2024 at 6:03 pm #16297393

Bobby
Supporter

Languages: English (English )

Timezone: America/Los_Angeles (GMT-08:00)

Hi there,

Unfortunately, performance issues are not always caused by the same reasons. We can of course go through a few standard tests and if they don't help we will need to look deeper.

1. Please update WPML and it's plugins to their latest versions https://wpml.org/downloads/

2. I can see you are using a custom theme, what are your results if you switch temporarily to a theme such as Twenty24? Please share the loading time with me then.

3. Consider disabling "display as translated" (Fallback mode) from post types, taxonomies, custom fields, etc. in WPML > Settings

4. Go to WPML->Support->Troubleshooting and run:
Cleanup and optimize string tables"
"Clear invalid strings"
"Remove ghost entries from WPML tables"

5. Consider using the plugin Index WP MySQL For Speed
https://wordpress.org/plugins/index-wp-mysql-for-speed/

Let me know your results, please.

The topic ‘[Closed] Thousands of DB queries when listing pages / post types in admin area’ is closed to new replies.