Large scale number of posts (100,000+) in WP (or, how big is yours ...) (4 posts)

  1. ekgermann
    Posted 10 years ago #

    I'm experimenting with using WordPress as an archiver/CMS for various mailing lists. I'm running an import of the archives of the list using a custom PERL (*cough*) script that directly puts them in to the db right now.

    I'm currently at 51,000+ posts and looking at probably 70,000+ for this list (1992-present). WordPress does an excellent job of handling dates before it was born :)

    So I'm curious, anyone out there running WordPress with 100,000+ posts? I'm contemplating using it as a knowledge management system for various email lists for searchability and RSS output (eventually to Urchin for intelligence).


  2. Denis de Bernardy
    Posted 10 years ago #

    I'd look at solutions that use stored procedures, i.e. not MySQL based, but rather PGSQL or TSQL.

    That said, MySQL is probably good enough for a small DB like yours.

  3. Rob Poitras
    Posted 10 years ago #

  4. ekgermann
    Posted 10 years ago #

    Fundamentally though, I think there is a significant difference between implementing a site with a relatively few number of pages with a large number of hits, and a site with a large number of entries in the posts table which takes a low to moderate hit count.

    The former can be optimized with something like WP-Cache or a front end proxy caching. The latter is much more difficult to optimize since it exposes underlying query and SQL performance issues.


Topic Closed

This topic has been closed to new replies.

About this Topic


No tags yet.