What happens to abandoned metadata when deleting?
I have a very large list of Lexicon terms (ca_list_item ) that is always creating memory issues, so I am thinking strongly of moving the lexicon to an information service. The information service is working fine.
My question is: If I remove the list, and remove the fields from the editors, what happens to the data left behind in the database (ca_objects_x_ca_list_items?)? Will each object's record end up with orphaned metadata from the removed list? Or will it somehow get purged? I know caUtills can remove soft-deleted relationships, etc, but does it deal with orphaned metadata?