Tierra Lab
New! WPDB Profiling 1.0.2 Released
We are pleased to announce our first publicly released plugin for WordPress. Too often, we have found the need for full database query profiling on a page by page basis. Using this tool allows us to optimize projects & plugins that are in development.
This plugin will give you the total number of queries to the db per page, as well as the total time it took to render those queries out to the page. Additionally, line by line each individual query will display with the originating SQL statement, time executed and the function call used to execute the query.
This is especially handy if you are debugging a slow WordPress install and can’t seem to locate the cause of the load. It is also a great way to identify plugins that may not have proper caching enabled or supported.
We hope you will find it useful as it has made our daily work with WordPress much easier.
To install, copy the folder into your plugins folder and enable it via the WordPress Plugin Manager. Since it uses a $_GET parameter, just append to the end of your url “?show_queries=yes” and you’ve got profiling. Don’t forget to follow the readme.txt file and add “define(‘SAVEQUERIES’, true);” to your wp-config.php file.
You can download the plugin here!
6 Responses to “New! WPDB Profiling 1.0.2 Released”
Leave a Reply
Copyright © 2010 Tierra Innovation, Inc.
| 
RSS | Client Login
A New Support Site
Flickr Feed
Recent Comments
- I want to thank you for yet another fantastic post. I am always searching for great WordPress tips ... (Carol)
- You can also use json_decode(), which is useful for those comfortable with javascript. $myObject = json_decode('{"foo":"bar"}')); It'll return null on failure, cheers! (sj)
- Is there a way to filter so that I only see those queries generated by my plugin or theme? (Zerzix)
January 16th, 2009 at 11:39 am
I have started using your tool, which is nice, simple, and effective. I added some code that will break down time used by function, which was very helpful for us. If you’d like, I’d be happy to send you the code. Currently it makes a definition list with the function name as the definition term and the time as the definition description. You may want to reformat that to use a table like you currently have, but that would be simple enough.
Let me know if you want it: http://xavisys.com/contact-us/?reason=WPDB+Profiling+Code
January 23rd, 2009 at 12:58 pm
Thanks Aaron – we added your code to version 1.0.1 and fixed a bug with PHP 5.2.1 and also styled the stats so they look more appealing. We’ll be adding more functionality to this plugin in the future.
February 8th, 2009 at 11:03 pm
It looks great and the added functionality makes it much more useful. Thanks!
May 5th, 2009 at 7:54 am
[...] WPDB Profiling Clean Options WP Tuner SQL Monitor [...]
June 5th, 2009 at 1:13 pm
I’m using Debug Queries plugin, it has the same functions as this one, and maybe it’s easier to install, run.
June 27th, 2009 at 11:37 am
[...] WPDB Profiling [...]