how efficient is the WordPress database

  • trevorNanders

    (@trevornanders)


    7 years, 8 months ago

    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

    (@macmanx)

    Volunteer Moderator

    7 years, 8 months ago

    I’ve seen much larger get by just fine. 🙂

    Some tips and recommendations: https://codex.wordpress.org/WordPress_Optimization

    And, some peace of mind: https://wordpress.org/showcase/ especially https://wordpress.org/showcase/tag/news/

    David Favor

    (@dfavor)

    7 years ago

    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.