Re: [sqlite] .dump-n-reload vs. vacuum - which is better?

[EMAIL PROTECTED] wrote: mr sql wrote: > I found out that doing a: > > sqlite3 my.db .dump > mydump.sql > rm my.db > sqlite3 my.db < mydump.sql > > is faster than doing a VACUUM on my.db. > > Are there any advantages of doing one over the other? My

[sqlite] .dump-n-reload vs. vacuum - which is better?

I found out that doing a: sqlite3 my.db .dump > mydump.sql rm my.db sqlite3 my.db < mydump.sql is faster than doing a VACUUM on my.db. Are there any advantages of doing one over the other? My goal is to keep the database's structures in their best shape for performance and integrity. So I

[sqlite] problems with 3.2.5

I have encountered some problems when upgrading to 3.2.5 from 3.2.2. I am using the sqlite3.dll from a delphi application (windows xp), not the sqlite3.exe 1. Order of returned records in a SELECT sometimes is not the same as 3.2.2, when statement does not have an "ORDER BY". As an