It depends on content and context. Options with autoload = yes are loaded very early, all in one query. This is pretty fast, but it might be too early when an options contains a serialized object whose class isn’t loaded yet. Options with autoload = no are loaded when get_option() is called. Use yes when … Read more
Calculate average crossing post categories
Is there an atomic way to update_option in WordPress (to ensure data integrity)?
The environment I work in has a development, staging and production server. We set up a Git repository and don’t track the wp-config file. We always copy the DB down, production -> staging -> development, and not the other way around. Only thing you have to do when you pull commits after your create plugins, … Read more
Export your tables using phpmyadmin interface. Just select those tables only that you want to export from the old database and import those tables in the new database or you can run the command(query) in mysql to copy one table create table newdbname.newtablename like olddbname.oldtablename; INSERT INTO newdbname.newtablename SELECT * FROM olddbname.oldtablename; Repeat the same … Read more
Slow wp-admin due to “SELECT DISTINCT post_mime_type FROM wp_posts WHERE post_type=”attachment””
Child parent relationship inside WP DB
I’m currently dealing with a site using W3TC plugin and that plugin seems to provide a custom database handler which actually caches queries to memcache. Give that a try. Sidenote: Just make sure, in case you are using multiple production servers, to use a shared memcache server and that you don’t cache those queries on … Read more
Store partial database to an archive database time to time
localize elements in database