--- Dennis Cote <[EMAIL PROTECTED]> wrote: > You could also improve the locality in the database file further by > running a vacuum command after it has been created. this will move the > pages around so that the page of the table are contiguous and so are the > pages of the index, rather than having them interspersed with each other.
In SQLite 3.3.13 and earlier, VACUUM does indeed intermix the table pages with the index pages leading to fragmentation. It's also quite slow on large tables with multiple indexes unless you use a large cache. This patch in CVS address these problems: http://www.sqlite.org/cvstrac/chngview?cn=3643 See also: Changes to support fragmentation analysis in sqlite3_analyzer. http://www.sqlite.org/cvstrac/chngview?cn=3634 ____________________________________________________________________________________ Need Mail bonding? Go to the Yahoo! Mail Q&A for great tips from Yahoo! Answers users. http://answers.yahoo.com/dir/?link=list&sid=396546091 ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------