Recent

Author Topic: SqlLite and file dimension  (Read 306 times)

berghem

  • Jr. Member
  • **
  • Posts: 56
SqlLite and file dimension
« 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?

Gustavo 'Gus' Carreno

  • Hero Member
  • *****
  • Posts: 510
  • Professional amateur ;-P
Re: SqlLite and file dimension
« Reply #1 on: April 04, 2021, 09:38:18 pm »
Hey Bergham,
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.

Cheers,
Gus
Lazarus 2.1.0(trunk) FPC 3.3.1(trunk) Ubuntu 20.10 64b Dark Theme
Lazarus 2.0.12(stable) FPC 3.2.0(stable) Ubuntu 20.10 64b Dark Theme
http://github.com/gcarreno

 

TinyPortal © 2005-2018