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

CC BY-SA 3.0
2016-04-16T19:51:25.240Z
If it's your first plugin, this is a great place to get the starting framework: https://pluginfactory.io
andrew.welch
CC BY-SA 3.0
2016-01-13T09:26:15.963Z
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 ;)
Bob Donderwinkel
CC BY-SA 3.0
2016-01-10T20:20:31.577Z
2016-01-10T20:20:31.577Z
Brad Bell
<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>

CC BY-SA 3.0
2016-01-10T19:25:40.807Z
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
Mutual
CC BY-SA 3.0
2016-01-10T19:27:19.580Z
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.
Mutual
<entries><database><entry><performance>
How many entries could the Craft database hold before it slows down?
# 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 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 ;)  
> **username_3**: If it's your first plugin, this is a great place to get the starting framework: https://pluginfactory.io  

---

