SQL History
Over the years my Tab/Sql History became huge, and it is working very slow. I am looking for a way to clean up.
1. There is no way to select multiple lines to delete. Delete is available only for one row. For example, every ALTER PROCEDURE creates history. I don’t need it at all. I would like to find all of them and delete.
2. There is no functionality to compress and reindex Sql History database.
3. Ironically “Send Feedback” link on a bottom of screen leads to nowhere.
![](https://secure.gravatar.com/avatar/08b6a471826b59e13edb1cac43a85f6d?size=40&default=https%3A%2F%2Fassets.uvcdn.com%2Fpkg%2Fadmin%2Ficons%2Fuser_70-6bcf9e08938533adb9bac95c3e487cb2a6d4a32f890ca6fdc82e3072e0ea0368.png)
-
On, 2:
After 7 days some snapshots are removed (query edited and connection changed) and then VACUUM is run on the SqlHistory.db file which rebuilds the database file, repacking it into a minimal amount of disk space.
Does this cover what you're looking for here, or would adding the option still be useful?
-
Quick update on 3 - the latest version of Prompt has removed this feedback link.
I'll come back to you on the other requests.