Re: [sqlite] SQLite auto_vacuum doesn't work?

[Simon Slavin]

On 19 Mar 2014, at 10:53pm, m.d.berce...@gmail.com wrote:

> I'm running the "pragma auto_vacuum = 'full'" a C++ code, then I go to 
> SQLiteSpy, open the database and run pragma auto_vacuum in the query window 
> and the result is 0. 

The syntax is

PRAGMA auto_vacuum = FULL

no quotes or apostrophes.

> I tried "pragma auto_vacuum = 1" and still the same, it doesn't seem to 
> keep the setting.

According to the documentation for the command you need to issue the 'VACUUM' 
command to change the status of an existing database:



Simon.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] SQLite auto_vacuum doesn't work?

[m . d . berceanu]

Hi there,
I'm running the "pragma auto_vacuum = 'full'" a C++ code, then I go to 
SQLiteSpy, open the database and run pragma auto_vacuum in the query window 
and the result is 0. 
I tried "pragma auto_vacuum = 1" and still the same, it doesn't seem to 
keep the setting.
I have some tables that get written and truncated a lot, and the size of 
the database grows out of control if I don't clean it up periodically.
Please help, any suggestions are highly appreciated.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users