I'd recommend NONE (or 0).
If you have fairly balanced insertions and deletions then there will
be no excessive disk space consumption, vacuuming won't help much. But
with auto-vacuuming turned on you won't have the same performance
because additional code will be executed after each transaction.
Hi All,
I have the database which has a lot of insertion and deletion. Do you have any
recomendation about what value that need to be set for auto_vacuum
in this case to improve the performance for deletion as well as insertion the
new row to the database. (0 | NONE | 1 | FULL | 2 | INCREMENTAL;)
Raviv Shasha wrote:
>
> Can I run the PRAGMA command without using sqlite3_exec command?
>
Well, yes you could use the prepared statement APIs, but generally
sqlite3_exec() is somewhat easier for statemnts you don't need to repeat
(like and insert).
> According to the sqlite documentation the
ilto:[EMAIL PROTECTED] On Behalf Of Dennis Cote
Sent: Monday, March 03, 2008 6:48 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] PRAGMA auto_vacuum
Raviv Shasha wrote:
>
> Sqlite_exec (pDB, "PRAGMA auto_vacuum = 1", NULL, 0, &errMsg);
>
Raviv,
That is correct
Raviv Shasha wrote:
>
> Sqlite_exec (pDB, "PRAGMA auto_vacuum = 1", NULL, 0, &errMsg);
>
Raviv,
That is correct, but you should not the following detail from
http://www.sqlite.org/pragma.html
> Therefore, auto-vacuuming must be turned on
> before any tables are created. It is not possible to
Hi all,
I'll appreciate if anyone can send me the correct syntax for executing
PRAGMA auto_vacuum = 1 command.
In the sqlite documentation there is only a list of all available PRAGMA
commands, but I didn't find any code examples.
Do I need to execute the PRAGMA auto_vacuum via sqlite_
6 matches
Mail list logo