Re: [sqlite] Fwd: System.Data.SQLite support incremental_vacuum

2016-06-10 Thread Ondra Medek
>> 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.

Re: [sqlite] Fwd: System.Data.SQLite support incremental_vacuum

2016-06-09 Thread Joe Mistachkin
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,

[sqlite] Fwd: System.Data.SQLite support incremental_vacuum

2016-06-09 Thread Ondra Medek
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