--- [EMAIL PROTECTED] wrote: > 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.
With non-volatile RAM drives getting larger and cheaper by the day, you may not need to worry about fragmentation, fsync and disk-seek time in a year or two. ____________________________________________________________________________________ Expecting? Get great news right away with email Auto-Check. Try the Yahoo! Mail Beta. http://advision.webevents.yahoo.com/mailbeta/newmail_tools.html ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------