Re: [sqlite] Fwd: System.Data.SQLite support incremental_vacuum
>> I have auto_vacuum = 2. ... >> Does .NET version support the "incremental_vacuum" feature or am I Yes; however, the database "auto_vacuum" mode must be set to "incremental" > first, per: > I have set auto_vacuum already, see my post. The incremental_vacuum runs well from the SQLiteStudio. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Fwd: System.Data.SQLite support incremental_vacuum
Ondra Medek wrote: > > Does .NET version support the "incremental_vacuum" feature or am I > doing something wrong? I am sure no other connection to the db exists > at the time the SQL command/query is issued. > Yes; however, the database "auto_vacuum" mode must be set to "incremental" first, per: https://www.sqlite.org/pragma.html#pragma_incremental_vacuum -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Fwd: System.Data.SQLite support incremental_vacuum
Hi, I am trying tu run "pragma incremental_vacuum" in .NET System.Data.SQLite 1.0.101.0 and it does nothing. I have auto_vacuum = 2. I can run "pragma incremental_vacuum" well from SQLiteStudio (sqlite_version 3.8.10). Does .NET version support the "incremental_vacuum" feature or am I doing something wrong? I am sure no other connection to the db exists at the time the SQL command/query is issued. Thanks Ondra Medek ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users