Request: Invetigate profile-cleaner reindex

Submitted by BBUser on Sun, 06/28/2015 - 20:09
Forums: 
Discussion

Hi,

Andrew have you seen/heard of profile-cleaner?

https://github.com/graysky2/profile-cleaner/

This is only for sqlite3's vacuum and reindex functions, and I wonder if bleachbit is doing what it does, or maybe you can improve upon Bleachbit, if this does something different?

thanks

andrew

Sun, 06/28/2015 - 20:37

The vacuuming is probably the same, but BleachBit 1.8 does not call REINDEX. Feel free to file a bug/wish ticket https://bugs.launchpad.net/bleachbit/, and later I will check whether REINDEX has a real benefit

---
Andrew, lead developer

BBUser

Mon, 06/29/2015 - 15:07

Hi Andrew,

Ok thanks, and done!

https://bugs.launchpad.net/bleachbit/+bug/1469884

ROCKNROLLKID's picture

ROCKNROLLKID

Sun, 07/05/2015 - 15:08

Just curious, does reindex have any beneficial values?

____________________
Also known as Alex.

Moderator for BleachBit and a maintainer for Winapp2.

Check out my open-source group on Steam: http://steamcommunity.com/groups/opencommunity

Windows 10 x64 (switching to ReactOS in the future).

andrew

Mon, 07/06/2015 - 09:35

According to the SQLite documentation

The REINDEX command is used to delete and recreate indices from scratch. This is useful when the definition of a collation sequence has changed

Similar to VACUUM, REINDEX can be easily run on all tables in the SQLite database.

Based on a little research, the SQLlite ANALYZE command looks more likely to improve performance than the SQLite REINDEX command.

The ANALYZE command gathers statistics about tables and indices and stores the collected information in internal tables of the database where the query optimizer can access the information and use it to help make better query planning choices.

So all three commands (VACUUM, REINDEX, and ANALYZE) may sometimes improve performance (and other times do nothing), but because they are safe and fast, they look like good options for general maintenance.

---
Andrew, lead developer

BBUser

Sat, 07/11/2015 - 01:27

the definition of a collation sequence has changed....

LOL, I'm clueless here, you could of easily said anything...

The Spam in The Can Became Ham, yes the definition of a collation sequence of that spam has changed! LMAO... :)

Thanks for checking...