SqlLite and file dimension
lazarus / 16-Databases

----------------------------------------------------------------------
berghem · 2021-04-04 19:25

Hi all
In my application I am using sqllite, but I see that after delete
record the file dimension is the same.
Is there some command to delete definitely records?

----------------------------------------------------------------------
Gustavo 'Gus' Carreno · 2021-04-04 19:38

Hey Bergham,
Quote from: berghem on April 04, 2021, 09:25:10 pmIn my application I
am using sqllite, but I see that after delete record the file
dimension is the same.
Is there some command to delete definitely records?

You have to vacuum your database: How SQLite VACUUM Optimizes Your
Database.

Cheers,
Gus