6

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

  • Not able to answer this myself but you might find this useful reading: stackoverflow.com/questions/1276/… – Mutual Jan 10 '16 at 19:25
  • 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 Jan 10 '16 at 19:27
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.

  • 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 Jan 13 '16 at 9:26
  • 2
    If it's your first plugin, this is a great place to get the starting framework: pluginfactory.io – andrew.welch Apr 16 '16 at 19:51

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.