Joe Wilson <[EMAIL PROTECTED]> wrote: > > As for the stats from sqlite3_analyzer, they seem to be in the right ballpark. > But I'm not sure its heuristic accounts for rows that are significantly larger > than the page size, though. In such cases I am seeing higher than expected > fragmentation after a VACUUM. This is just a guess, of course. >
I'm not sure sqlite3_analyzer does any of the fragmentation measurement right. For that matter, how do you measure fragmentation with a number? (Suggestions are welcomed.) I may yet just yank that whole fragmentation measurement idea. -- D. Richard Hipp <[EMAIL PROTECTED]> ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------