Answers.Body: <p>It's a bit of a loaded question, but generally it's going to depend more on environmental limitations than anything with Craft itself.</p>
  
  <p>If you're on a shared host along with 200 other accounts using the same MySQL server, then you'll likely notice slowdowns sooner than later.</p>
  
  <p>If you're on a decent host with plenty of memory/disk/CPU available, then we've seen sites with 500k users/entries/assets/etc. running along just fine.</p>
  
  <blockquote>
    <p>And is there perhaps a way to automatically delete entries after x amount of time?</p>
  </blockquote>
  
  <p>As Andrew pointed out in the comments, you could write a simple plugin that exposes a controller action that gets all entries over a certain age and deletes them.  Then you'd setup a CRON job to call that controller endpoint on whatever schedule you want.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-04-16T19:51:25.240Z
Answers.Text: If it's your first plugin, this is a great place to get the starting framework: https://pluginfactory.io
Answers.UserDisplayName: andrew.welch
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-01-13T09:26:15.963Z
Answers.Text: Thanks Andrew en Brad, i'm going to check out the cron job for deleting entries, and perhaps cancelling stuck tasks as well. Would there be an example available somewhere? this would be my first plugin ;)
Answers.UserDisplayName: Bob Donderwinkel
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-01-10T20:20:31.577Z
Answers.LastActivityDate: 2016-01-10T20:20:31.577Z
Answers.UserDisplayName: Brad Bell
Body: <p>I'm pulling in some RSS feeds using Feed Me (<a href="https://github.com/engram-design/FeedMe">https://github.com/engram-design/FeedMe</a>) and turning those in entries automatically using a cron job.</p>
  
  <p>You can imagine that producing a lot of entries over time ;) Is there a known limit for entries in the Craft database?</p>
  
  <p>And is there perhaps a way to automatically delete entries after x amount of time?</p>
  
  <p>Thanks, Bob</p>
  
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2016-01-10T19:25:40.807Z
Comments.Text: Not able to answer this myself but you might find this useful reading: http://stackoverflow.com/questions/1276/how-big-can-a-mysql-database-get-before-performance-starts-to-degrade
Comments.UserDisplayName: Mutual
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2016-01-10T19:27:19.580Z
Comments.Text: Also regarding automatic deletion. You could achieve that by writing a simple plugin that gets all entries over a certain age then delete them and calling that through CRON also.
Comments.UserDisplayName: Mutual
Tags: <entries><database><entry><performance>
Title: How many entries could the Craft database hold before it slows down?
ThreadText: # How many entries could the Craft database hold before it slows down?
  
  (Asked by: username_0 on 2016-01-10)
  
  I'm pulling in some RSS feeds using Feed Me (<https://github.com/engram-design/FeedMe>) and turning those in entries automatically using a cron job.
  
  You can imagine that producing a lot of entries over time ;) Is there a known limit for entries in the Craft database?
  
  And is there perhaps a way to automatically delete entries after x amount of time?
  
  Thanks, Bob
  
  **Tags:** entries, database, entry, performance
  
  > **Comments:**
  > **username_1**: Not able to answer this myself but you might find this useful reading: http://stackoverflow.com/questions/1276/how-big-can-a-mysql-database-get-before-performance-starts-to-degrade  
  > **username_1**: Also regarding automatic deletion. You could achieve that by writing a simple plugin that gets all entries over a certain age then delete them and calling that through CRON also.  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_2 on 2016-01-10. Score: 6
  
  It's a bit of a loaded question, but generally it's going to depend more on environmental limitations than anything with Craft itself.
  
  If you're on a shared host along with 200 other accounts using the same MySQL server, then you'll likely notice slowdowns sooner than later.
  
  If you're on a decent host with plenty of memory/disk/CPU available, then we've seen sites with 500k users/entries/assets/etc. running along just fine.
  
  > And is there perhaps a way to automatically delete entries after x amount of time?
  
  As Andrew pointed out in the comments, you could write a simple plugin that exposes a controller action that gets all entries over a certain age and deletes them. Then you'd setup a CRON job to call that controller endpoint on whatever schedule you want.
  
  > **Comments:**
  > **username_0**: Thanks Andrew en username_2, i'm going to check out the cron job for deleting entries, and perhaps cancelling stuck tasks as well. Would there be an example available somewhere? this would be my first plugin ;)  
  > **username_3**: If it's your first plugin, this is a great place to get the starting framework: https://pluginfactory.io  
  
  ---
  
  