Run vacuum SQLite

[gandalf]

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

[AlexP]

Hello,

You can call the VACUUM command in the following way:

Code: Select all

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

or use PRAGMA for setting auto_vacuum

Code: Select all

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

[gandalf]

Thank you for the info!

[AlexP]

Hello,

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