Title: how efficient is the WordPress database
Last modified: September 1, 2016

---

# how efficient is the WordPress database

 *  [trevorNanders](https://wordpress.org/support/users/trevornanders/)
 * (@trevornanders)
 * [9 years, 9 months ago](https://wordpress.org/support/topic/how-efficient-is-the-wordpress-database/)
 * Just wondered how optimised/efficient a standard WordPress install database is?
 * I noticed that a single post can generate many database inserts/updates and the
   meta tables have hundreds of rows/columns for only a few posts and pages so far.
 * Just wondering how it will cope after 2 years and (by the looks of it) many thousands
   of database queries/updates and inserts on a daily basis.
 * I have moved my website from an old cms into WordPress. The old site has/had 
   5,685 Members and 26,142 posts & about 150,000 comments.
 * How would this figure fair with a WordPress CMS?
 * thanks

Viewing 2 replies - 1 through 2 (of 2 total)

 *  Moderator [James Huff](https://wordpress.org/support/users/macmanx/)
 * (@macmanx)
 * [9 years, 9 months ago](https://wordpress.org/support/topic/how-efficient-is-the-wordpress-database/#post-7656181)
 * I’ve seen much larger get by just fine. 🙂
 * Some tips and recommendations: [https://codex.wordpress.org/WordPress_Optimization](https://codex.wordpress.org/WordPress_Optimization)
 * And, some peace of mind: [https://wordpress.org/showcase/](https://wordpress.org/showcase/)
   especially [https://wordpress.org/showcase/tag/news/](https://wordpress.org/showcase/tag/news/)
 *  [David Favor](https://wordpress.org/support/users/dfavor/)
 * (@dfavor)
 * [9 years, 1 month ago](https://wordpress.org/support/topic/how-efficient-is-the-wordpress-database/#post-9035914)
 * Better to focus on tuning your LAMP Stack (Linux/Apache/MySQL/PHP).
 * Recently I took on a new client with a front page load time of 20 seconds.
 * After migrating out of his very expensive hosting (which shall rename nameless),
   onto one of my well tuned servers…
 * Page load speed went from 20 seconds to 5 seconds.
 * Then disabling W3TC (which usually slows sites down, contrary to myth)…
 * Page load speed went from 5 seconds to 2 seconds.
 * No WordPress changes, just correctly tuned LAMP stack.
 * All CMS systems produce high LAMP load, so steps for speed…
 * 1) Tune your LAMP stack till it’s blistering fast. My target is 60,000+ reqs/
   sec serving simple .txt files. If simple file serving is slow, WordPress will
   be slower.
 * 2) Test your specific theme + specific plugins. Most WordPress.org themes will
   work well with WP Super Cache. My target is 3,000+ reqs/sec for front page using
   wptest.io data for testing.
 * Note, many so called premium themes are riddle with backdoors + are so poorly
   written, many slow down when caching plugins are enabled.
 * Always test. Never just install some theme or caching plugin + imagine speed 
   will ensue.
 * Only testing tells the truth.

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘how efficient is the WordPress database’ is closed to new replies.

## Tags

 * [efficiency](https://wordpress.org/support/topic-tag/efficiency/)
 * [performance](https://wordpress.org/support/topic-tag/performance/)
 * [speed up](https://wordpress.org/support/topic-tag/speed-up/)

 * In: [Everything else WordPress](https://wordpress.org/support/forum/miscellaneous/)
 * 2 replies
 * 3 participants
 * Last reply from: [David Favor](https://wordpress.org/support/users/dfavor/)
 * Last activity: [9 years, 1 month ago](https://wordpress.org/support/topic/how-efficient-is-the-wordpress-database/#post-9035914)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics