[Plugin: WP Changes Tracker] too many DB results and bloated table…

Was trying to figure out why I could visit any page in wp-admin except the dashboard (timed out and 500 error), finally found that on my site, the problem with this plugin is the sheer number of database results it is grabbing by default: 136,146! That is simply too much data to go and retrieve all at once, especially considering how large some of the individual rows are.

I have added 2 lines to the wp_changes_tracker::display_log() method. I changed these lines…

if($this->options[‘max_log_entries_to_display’]>0){
$sql .= ‘ LIMIT ‘.$this->options[‘max_log_entries_to_display’];
}

… to this instead…

if($this->options[‘max_log_entries_to_display’]>0){
$sql .= ‘ LIMIT ‘.$this->options[‘max_log_entries_to_display’];
} else {
$sql .= ‘ LIMIT 10’;
}

This forces the default to only display the last 10 entries, instead of displaying all 136,146 entries.

There is absolutely no reason to default to grabbing so many rows of data all at one time. Also, the table for WP-tracker had grown to 300MB, in a DB that would otherwise be only 6MB.

http://wordpress.org/extend/plugins/wp-changes-tracker/