Devart Forums

Posted: **Fri 16 Mar 2012 18:26**

Is it possible to do a vacuum on a SQLite database via UniDac?

Posted: **Mon 19 Mar 2012 12:15**

Hello,

You can call the VACUUM command in the following way:

  UniConnection1.ExecSQL('VACUUM',[]);

or use PRAGMA for setting auto_vacuum

  UniConnection1.ExecSQL('PRAGMA auto_vacuum = 1',[]); // 0 | NONE | 1 | FULL | 2 | INCREMENTAL

Posted: **Mon 19 Mar 2012 15:26**

Thank you for the info!

Posted: **Mon 19 Mar 2012 15:34**

Hello,

If you have any other questions, feel free to contact us.

Run vacuum SQLite