|
Are you sure you aren't sorting on the approximate formats? That might explain the speed boost.
I remember rebuilding databases over weekends to improve performance. Like defragmenting a harddrive. Not sure if sqlite benefits from that... Perhaps that was what happened when you removed and added the formats column?
|