Thread tagged as: Question, Runway

Deleting a collection

My collection index table currently has 8235736 rows, I need to clear delete a specific collection.

If I delete this collection from the CMS will it delete the individual collection items from the database?

If not and I delete manually from the database are there any other tables I need to consider other than collections_index collection_items collection_revisions

Many thanks

Lee Goodman

Lee Goodman 0 points

  • 4 years ago
Drew McLellan

Drew McLellan 2638 points
Perch Support

There's no problem having lots of content indexed. That's what the index is for.

Deleting an individual item cleans up behind it, removing items from the index etc.

Looks like deleting an entire collection does not clean up the individual items, so I'll log that.

Hi Drew,

Thanks for the response. Unfortunately the 8235736 rows in the index are a result of an issue from importing a collection via an add on, so need to clear them down. There are 1652 collection items in the CMS so deleting manually item by item via the CMS is not an option.