[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
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
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 inmediate
3 matches
Mail list logo