WordPress.org

Ready to get started?Download WordPress

Ideas

More efficient database coding

  1. Niteblade
    Member

    12345

    As a wordpress site grows, database performance decreases significantly.

    A wordpress site that has hundreds of posts will experience high server loads caused by poor database coding. However, forum software that uses mySQL can have hundreds and even thousands of posts without such noticeable defects in database speed.

    I wish that WordPress could take some database structure cues from popular forum software manufacturers such as vBulletin, Simple Machines, myBB, and phpBB.

    In order to duplicate poor performance associated with poor WordPress database coding (even on a dedicated server), it is recommended to make use of plugins that translate RSS feeds into WordPress Blog entries. This will allow the creation of a lot of blog posts within a short period of time. As the database grows, attempt to create a hand-written blog entry. You'll notice that it takes WordPress several minutes of processing time (accompanied with high server load) before you can begin writing your post.

    Of course, if you have a blog that has several dozens of authors generating pages upon pages of fresh content, you'll also notice that it takes longer and longer to publish an individual post.

    Posted: 5 years ago #
  2. Jacob Santos
    Member

    12345

    The assertion that using plugins that translate RSS feeds into WordPress Blog entries to save processing is incorrect. You would have a greater overhead from the HTTP latency coupled with the XML processing, which would be done by regex, since WordPress still supports PHP 4.

    There is no correlation from writing a post and the amount of posts that exist. WordPress does not load those posts in order for you to write your post. You might be noticing a delay from the amount of JavaScript that is required, which might be slowing the rendering of the page in the browser.

    If the Database server is experiencing high loads, try switching from INNODB to MYISAM, if possible.

    There are only a few areas (that are known) that require better SQL for performance reasons for handling pages. This must be address and it will be in the future.

    If you are experiencing high load with a few dozen authors and visitors, then yes the server is going to take a longer time to create the page (if it even finishes). If you have that many visitors and authors, you might want to invest either in a better server or a second server.

    Posted: 5 years ago #
  3. Niteblade
    Member

    12345

    The whole point in grabbing rss feeds, e.g., from Google News, and using a plugin to translate the rss feeds into a blog post is to grow the WP database size in a short amount of time. While there is certainly overhead from the translation process itself, the overhead (high server load and sluggish behavior) continues even after the translation procedure has completed.

    I can't think of any other reason other than the size of the database itself that impairs WP speed.

    Let's say a cron-job has been setup to grab rss from Google News once per hour. There is high server load associated with the particular time that the translation process is happening. And this is very understandable. 30 minutes after the designated time has passed, however, it still takes WP forever to allow a manual hand-written post to be created.

    Simply do a compare and contrast in terms of speed between a WP site that has 10 or even 100 blog entries verus a WP site that has 40,000 entries.

    My main point is that I suspect that WP's database structure is not designed to handle a blog site that has thousands of posts in it, whether those blog posts are legitimately created from hand or those blog posts are the result of rss scraping.

    Posted: 5 years ago #
  4. Jen Mylo
    Key Master

    Niteblade: How do you reconcile your suggestion that "WP's database structure is not designed to handle a blog site that has thousands of posts in it, whether those blog posts are legitimately created from hand or those blog posts are the result of rss scraping," when WordPress.com has millions of posts and seems to run just fine? Your statement that with a lot of entries "it takes WordPress several minutes of processing time" before you can begin writing a post is not something I've ever encountered. I'm closing this, because it sounds like a support issue.

    Posted: 4 years ago #

RSS feed for this topic

Topic Closed

This topic has been closed to new replies.

  • Rating

    12345
    3 Votes
  • Status

    Sorry, not right now