Jump to content

More clever compacting of SQLite databases


Recommended Posts

CCleaner could analyze Sqlite databases before trying compact them. Use PRAGMA freelist_count; and PRAGMA page_count; (info). CCleaner should never try compact if freelist_count is 0. Also CCleaner could compact only if percent of free pages of total pages is above some limit.

I have several Firefox profiles, but I only use one of them actively, others very rare. But CCleaner takes much time trying re-compact databases of unused profiles, while it could skip them because they are already compacted saving me much time.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.