Lazarus

Programming => Databases => Topic started by: berghem on April 04, 2021, 09:25:10 pm

Title: SqlLite and file dimension
Post by: berghem on April 04, 2021, 09:25:10 pm

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?

Title: Re: SqlLite and file dimension
Post by: Gustavo 'Gus' Carreno on April 04, 2021, 09:38:18 pm

Hey Bergham,

Quote from: berghem on April 04, 2021, 09:25:10 pm

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?

You have to vacuum your database: How SQLite VACUUM Optimizes Your Database (https://www.sqlitetutorial.net/sqlite-vacuum/).

Cheers,
Gus