I have a Drupal 7.24 Website making heavy use of field collections.
The field_collection_item_revision keeps getting bigger and bigger (9'000'000 rows) and only 200'000 entries are in field_collection_item.
What is the most secure and efficient way to "clean" this table?
PS: A SQL request with nested selects is not an option, it's too slow.