You can delete all post via $wpdb DELETE FROM wp_posts WHERE post_type=”post_type”; DELETE FROM wp_postmeta WHERE post_id NOT IN (SELECT id FROM wp_posts); DELETE FROM wp_term_relationships WHERE object_id NOT IN (SELECT id FROM wp_posts) or use this query replace it with {{your CPT}} with your Custom Post Type DELETE a,b,c FROM wp_posts a LEFT JOIN … Read more
Profiling with Profiler-Plugins Not sure exactly what you need to accomplish with your profiling, but WP Tuner (WordPress Plugin) goes a long way to finding what is slowing down your WP install. It looks at each plugin and give your the memory, CPU time and SQL queries involved. The SQL Monitor (WordPress Plugin) analyzes SQL … Read more
Update: The reason the query is being logged is it doesn’t use an index. The query time is 0, i.e. it actually executes fast. You can unset the “log-queries-not-using-indexes” option if you don’t want these to be logged. The wp_options table has no index on autoload (it now should, it was added to WP core … Read more
The answer that yes, the theme_mod functions will be slower, but not significantly, and the benefits outweigh the differences. Theme mods are stored as options. So, in essence, the theme_mod functions are wrappers around the options functions. First, understand that theme_mod settings are stored as an array in a single option, keyed to the specific … Read more
late answer From a brief look: You’d have to use include( admin_url().’load-scripts.php’ ); and include( admin_url().’script-loader.php’ ); Then jump into $GLOBALS[‘wp_scripts’]: Use… $wp_scripts->default_dirs( array_merge( $wp_scripts->default_dirs ,array( ‘/themes/your_theme/js/’ ) ); …to extend it. And then use $wp_scripts->add( $handle, $path_from_content_dir, false/array( $deps ), $ver ) to add a script. Notes: Uncompressed scripts get searched by .dev.js (when … Read more
On shared hosting plans your caching options are limited. You will only be able to statically cache the html output from your pages. This is the fastest way to serve pages but you loose the dynamic aspects of WordPress like making comments and seeing the latest comments on posts. There are disk caching options available … Read more
Clearly nothing scales as well as static files served by a fast web server and any CMS that has to figure out what to load and then load it will not perform as well, WordPress or otherwise. One of the issues is the number of database queries required per URL request and my 2 prior … Read more
Yep, this is nasty issue that to have full WordPress environment you need to spend considerable time loading it. I’ve needed much better performance (for very dynamic incremental search feature) for work and what I went with is: Custom file as Ajax handler. SHORTINIT constant for limited WP core load. Very selectively loaded parts of … Read more
No it doesn’t. At least, not on the front end, or in the back end in any non-plugin area. WordPress only loads files whose filepaths are stored in the active_plugins option in the database and ignores everything else completely.
You could install WordPress on Nginx. There are a number of resources to help: nginx Compatibility plugin HOWTO: Install WordPress On Nginx– Slicehost discussion How To Speed Up WordPress With Nginx And WP Super Cache WordPress on nginx + lighttpd + FastCGI + php Nginx as a front-end proxy cache for WordPress Some performance information … Read more