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

  • 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).

    Thoughts?

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

  • 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.

    https://photomatt.net/2005/05/18/high-traffic-sites/

    Thread Starter ekgermann

    (@ekgermann)

    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.

    Eric

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Large scale number of posts (100,000 ) in WP (or, how big is yours …)’ is closed to new replies.