This topic should be rewritten and moved to the feature request section.
Because summary: next to shooting with DELETE FROM statements at the recorder there currently is no option.
First collecting and deleting stuff afterwards is not very smart. Having a config option in advance (OR at least an easy to use cleanup option like a recorder service) certainly is.
Here is a summary also containing a link to a good how-to for removing LTS from the database: