Recent

« previous next »
Pages: [1]

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

berghem

  • Jr. Member
  • **
  • Posts: 60
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?
Logged

Gustavo 'Gus' Carreno

  • Hero Member
  • *****
  • Posts: 1120
  • Professional amateur ;-P
Re: SqlLite and file dimension
« Reply #1 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.

Cheers,
Gus
Logged
Lazarus 3.99(main) FPC 3.3.1(main) Ubuntu 23.10 64b Dark Theme
Lazarus 3.0.0(stable) FPC 3.2.2(stable) Ubuntu 23.10 64b Dark Theme
http://github.com/gcarreno
Pages: [1]
« previous next »
 

TinyPortal © 2005-2018