Optimize WP StatPress plugin database performance

Photo of author
Written By Jan Reilink

Windows Server systems administrator & enthusiast.

The WordPress plugin StatPress (no longer available in the Plugin Directory) is still widely used and still is very slow. Here are some MySQL statements you can use to optimize its performance, as a WordPress optimization tip…

All kudos go to Felipe Ferreira for this one. Read his post Statpress is slow to understand why I posted these MySQL statements here, and what they do.

Where necessary, replace wp_ with your own MySQL database table prefix.

ALTER TABLE wp_statpress MODIFY DATE INT(8) UNSIGNED NOT NULL; ALTER TABLE wp_statpress ADD KEY (date); ALTER TABLE wp_statpress MODIFY ip CHAR(15) NOT NULL; ALTER TABLE wp_statpress ADD KEY (ip); ALTER TABLE wp_statpress MODIFY spider VARCHAR(16); ALTER TABLE wp_statpress MODIFY feed VARCHAR(16);
Code language: SQL (Structured Query Language) (sql)

Optional:

ALTER TABLE wp_statpress ADD KEY (spider); ALTER TABLE wp_statpress ADD KEY (feed);
Code language: SQL (Structured Query Language) (sql)

Did you like: Optimize WP StatPress plugin database performance

Then please, take a second to support Sysadmins of the North and donate!

Your generosity helps pay for the ongoing costs associated with running this website like coffee, hosting services, library mirrors, domain renewals, time for article research, and coffee, just to name a few.



Hi! Join the discussion, leave a reply!