sqlite database grows after 'VACUUM'

dansot · 2013-08-27 16:35:38

I have a database with ~1mil records. If I delete 5000 entries and then 'VACUUM' it grows by 10MB. Am I doing something wrong?

After the deletions are committed I am issuing:

database.EngineExecuteAll('VACUUM');

Thanks!

ab · 2013-08-27 18:17:35

Sounds weird to me.

Usually vacuum decreases the file size...

What is your "database" class type?
In some cases, vacuum is a no-op..

dansot · 2013-08-27 19:26:37

It's TSQLRestServerDB

ab · 2013-08-27 20:31:20

Use its internal db property.

But it is not possible if you use virtual tables....

dansot · 2013-08-27 21:13:28

ok, I used database.db.executeall('VACUUM') but it didn't have any effect. I have two tables defined but I don't think they are virtual.

Last edited by dansot (2013-08-27 21:13:37)

ab · 2013-08-28 11:11:22

You can try database.db.Execute('VACUUM;');

dansot · 2013-08-28 14:34:43

That still adds 10MB to the file

ab · 2013-08-28 15:41:54

I do not understand it, honestly.
I've never seen such behavior.

mORMot Open Source