Title: How Many Posts
Last modified: August 20, 2016

---

# How Many Posts

 *  [dslippy](https://wordpress.org/support/users/dslippy/)
 * (@dslippy)
 * [15 years ago](https://wordpress.org/support/topic/how-many-posts/)
 * I am considering how to move a database of case law within a wordpress context.
 * An immediate question is how many is the maximum sensible number of entries? 
   I would be immediately making (automatically!) nearly 300k posts, and would have
   to assume an (unlikely) possibility of another 200k. Each case would be one entry.
 * I am still in the very early stages and looking where to invest time in development.
 * Would this be too many?
 * I see that some search facilities suggest a limit of 100k posts.

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

 *  [GRAQ](https://wordpress.org/support/users/graq/)
 * (@graq)
 * [15 years ago](https://wordpress.org/support/topic/how-many-posts/#post-2112853)
 * Just from a point of storage, the wp_posts table has a bigint(20)
    [http://codex.wordpress.org/images/9/9e/WP3.0-ERD.png](http://codex.wordpress.org/images/9/9e/WP3.0-ERD.png)
 * The max for an unsigned bigint(20) is 18,446,744,073,709,551,615
    So even with
   a lot of post revisions, attachments, and so forth, you should be OK. However
   there are other considerations.
 *  Thread Starter [dslippy](https://wordpress.org/support/users/dslippy/)
 * (@dslippy)
 * [15 years ago](https://wordpress.org/support/topic/how-many-posts/#post-2112859)
 * Thank you. It is the ‘other’ I need to consider.
 * I have an existing site but it has to move and to move on. It is all custom built
   code, and I have little desire to re-invent the wheel a second time.
 * Is there an obvious wordpress site with similar or substantially more postings?
 *  [esmi](https://wordpress.org/support/users/esmi/)
 * (@esmi)
 * [15 years ago](https://wordpress.org/support/topic/how-many-posts/#post-2112863)
 * [http://vip.wordpress.com/clients/](http://vip.wordpress.com/clients/)
 *  Thread Starter [dslippy](https://wordpress.org/support/users/dslippy/)
 * (@dslippy)
 * [15 years ago](https://wordpress.org/support/topic/how-many-posts/#post-2113003)
 * Thank you. Point gladly taken.
 *  Moderator [Ipstenu (Mika Epstein)](https://wordpress.org/support/users/ipstenu/)
 * (@ipstenu)
 * 🏳️‍🌈 Advisor and Activist
 * [15 years ago](https://wordpress.org/support/topic/how-many-posts/#post-2113060)
 * WordPress won’t be the issue. Your SERVER will be.
 * >  I would be immediately making (automatically!) nearly 300k posts, and would
   > have to assume an (unlikely) possibility of another 200k. Each case would be
   > one entry.
 * Someone else recently tried to do that on Shared Hosting and it went up in flames.
   You’re going to want at LEAST a good VPS for something that big.
 *  [GRAQ](https://wordpress.org/support/users/graq/)
 * (@graq)
 * [15 years ago](https://wordpress.org/support/topic/how-many-posts/#post-2113088)
 * > WordPress won’t be the issue. Your SERVER will be.
 * And in order to build a server that suits your needs, you should get a clearer
   idea of what you really need.
 * I won’t go into detail, but as a simple example, taking your first sentence as
   the de-facto requirements, I could make the following assumptions. 1) Each case
   law is pretty much like a static page (it’s not a blog entry with lots of comments
   or fancy widgets). 2) You just need to server up loads of these. Based on those
   two, it can be served it up nice and quick with a little caching.
 * The devil is in the detail, and that may cost you time and money!

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

The topic ‘How Many Posts’ is closed to new replies.

## Tags

 * [maximum posts](https://wordpress.org/support/topic-tag/maximum-posts/)

 * In: [Everything else WordPress](https://wordpress.org/support/forum/miscellaneous/)
 * 6 replies
 * 4 participants
 * Last reply from: [GRAQ](https://wordpress.org/support/users/graq/)
 * Last activity: [15 years ago](https://wordpress.org/support/topic/how-many-posts/#post-2113088)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics