WordPress.org

1. Johnny T
   Member
   Posted 2 years ago #

   Hi all,

   I have a website that has a WP backbone (currently running 2.9.2) and wondered how many posts that it will comfortably handle?

   Currently, I have around 8000 lines in my wp_posts database.

   I'm pretty unfamiliar with SQL etc but are there any limitations to WordPress? Does anyone know whether 8,000 lines in wp_posts will start to slow down the site or is this a snip ?

   Any ideas?

   Thanks

   John ;-)

2. James
   Happiness Engineer
   Posted 2 years ago #

   The official answer: It's only limited by the space available to your database, which varies depending on hosting provider, hosting package, etc.

   However, some performance impact has been noted on blogs with over 1,000 posts that start their permalink structures with /%postname%/, /%category%/, /%tag%/, or /%author%/.

   For more info, see this article:

   http://ottopress.com/2010/category-in-permalinks-considered-harmful/

3. Johnny T
   Member
   Posted 2 years ago #

   Ooops!! I have /%category%/%postname%/ as my permalink structure..

   Am I right in thinking that if I change it to:
   /%year%/%category%/%postname%/

   Then it will be ok??

   Thanks for all your help

   John ;-)

4. Johnny T
   Member
   Posted 2 years ago #

   Anyone else got any advice on this?
   I expect my site to have well in excess of 1,000 posts and really need to know whether changing my permalink to:
   /%year%/%category%/%postname%/

   Would help overcome the problems pointed out by macmanx

   Thanks for any assistance

   ;-)

5. MichaelH
   Volunteer
   Posted 2 years ago #

   According to Otto /%year%/%postname%/ would be better.

6. Johnny T
   Member
   Posted 2 years ago #

   Many thanks for that MichaelH although I'm curious as to the "according to Otto". Do you not think there is an issue? Or is just nothing you have seen?

   Thanks again...

   John ;-)

7. James
   Happiness Engineer
   Posted 2 years ago #

   Otto wrote the article that I linked to regarding the dangers of starting your permalink structure with /%postname%/, /%category%/, /%tag%/, and /%author%/. His preferred structure is /%year%/%postname%/ .

   http://ottopress.com/2010/category-in-permalinks-considered-harmful/

8. esmi
   Theme Diva & Forum Moderator
   Posted 2 years ago #

   I was wondering the other day whether /%post_id%/%postname%/ would be at least as effective, performance-wise, as /%year%/%postname%/. In theory, /%post_id%/ should be faster than that /%year%/ as it would, preseumably, be unique. Or is there something in the rewrite rules that I've not considered?

9. christo.ebe
   Member
   Posted 2 years ago #

   I have more than 4000 posts and its' growing. I hardly recognize any performance issue. I use a custom permlink.

10. Johnny T
    Member
    Posted 2 years ago #

    Thanks for all the great info. I'll look into changing my permalink structure as a result of what I've read here.

    Thanks again ;-)

Topic Closed

This topic has been closed to new replies.