How to disable `SQL_CALC_FOUND_ROWS` [duplicate]

First should only disable SQL_CALC_FOUND_ROWS if you aren’t using pagination, to do so set parameter no_found_rows to true in WP_Query. WP_Query( array( ‘no_found_rows’ => true ) ); Note get_posts() does that by default.

Best way to import users, post and categories from an external database

Unless there is a core WordPress import filter available for your CMS ( see http://codex.wordpress.org/Importing_Content ) or a plugin for a CMS not covered by core WP ( see http://wordpress.org/extend/plugins/search.php?q=import ), or a Google search for your database schema doesn’t reveal anything, you need to roll your own importer. The best way is to write … Read more

How to change option recently_edited?

The function is update_recently_edited in wp-admin/includes/misc.php. unfortunately it is fixed at 5: function update_recently_edited( $file ) { $oldfiles = (array) get_option( ‘recently_edited’ ); if ( $oldfiles ) { $oldfiles = array_reverse( $oldfiles ); $oldfiles[] = $file; $oldfiles = array_reverse( $oldfiles ); $oldfiles = array_unique( $oldfiles ); if ( 5 < count( $oldfiles )) array_pop( $oldfiles … Read more

WordPress Database Charset/Collate

There are $wpdb->charset and $wpdb->collate. I am not sure if or when one of these values might be empty, so it is better to prepare for empty values … From my DB class: /** * Get table charset and collation. * * @since 2012.10.22 * @return string */ protected static function get_wp_charset_collate() { global $wpdb; … Read more

delete_option() and update_option() returning false

The delete_option() function will return false if the option does not exist. The update_option() function will return false if the option already has the same value as what you’re trying to update it to. Both will also return false if the SQL query itself fails for whatever reason.