O. Jones
  • Member for 9 years, 11 months
  • Last seen this week
How best to handle database version dependence (from $wp_db_version)
1 votes

I sorted this out. It looks like the core team rolls out new versions of the database with their beta program. So, it's plenty easy to get advance warning. And, the database upgrades live in wp-admin/...

View answer
Gathering and logging data from a plugin: how to do it without race conditions?
1 votes

I finally solved my problem with this function. It appends to a transient in the MySQL database in a race-condition-safe way. /** Upsert and append data to a WordPress transient. * This function ...

View answer
Wordpress Query is taking more then 20 second and stuck on creating index
1 votes

Looking at your query, I see lots of stuff like wp_posts.post_content LIKE '%اهمية%'. You should know that column LIKE '%matchstring%' is a notorious MySQL performance-killer. If you can change your ...

View answer
How to solve slow WordPress site caused by attachment_metadata
1 votes

Rick James and I have created the (free, GPL) Index WP MySQL for Speed plugin. It addresses some of the performance problems with wp_postmeta by adding database indexes suitable for that table's use ...

View answer
I'm designing a plugin to create database indexes. Suggestions?
Accepted answer
1 votes

This plugin, Index WP MySQL for Speed, is released. GPLed source code is here. Anecdotal experience shows speedups on some big WP and WooCommerce sites. Here's the data definition language it runs to ...

View answer
How to translate wordpress backend to another language
1 votes

Just so you know, a Sinhala translation is already in progress. https://si.wordpress.org/ http://wpcentral.io/internationalization/si/ Maybe it would be a good idea to join that team. First, you ...

View answer
Fulltext search in posts sorted by relevancy
0 votes

This may or may not be important in your case, but FULLTEXT search works very strangely when there isn't very much text to search against. It's really a pain in the neck to test on a small data set. ...

View answer
Update a Wordpress post or page takes 60+ seconds
Accepted answer
0 votes

There's a plugin called Debug Bar which you can find at http://wordpress.org/plugins/debug-bar/ Don't leave this enabled in production! But it will tattle on slow MySQL queries. You might also wish ...

View answer
How to insert an Audio Player in a Post or Page?
0 votes

If you're on WordPress.com, you have the [audio URL] shortcode at your disposal. If you're on WordPress.org, you can install the Jetpack plugin to get that shortcode. The shortcode figures out ...

View answer