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)

This topic contains 1 reply, has 2 voices.

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.