Compacting a Database

[Smee]

Does anyone know of a way to do this from within B4ppc or is there an external program that could be run from within B4PPC

Thanks

Joe

 

[Cableguy]

You can delete all the empty alocated space from the database, using the "Vacuum" command...
this does not compact the database, but can shrink it a lot, especially if you use a lot of blobs....

 

[Erel]

As Cableguy wrote you should use the VACUUM command: SQLite Query Language: VACUUM

 

[Smee]

Many Thanks

Joe

 

[a_carignan]

I have to create the order
sql1.ExecnonQuery("vacuum")
but at the time of l' execution it marks a error; writing/Reading on the disc.
:sign0163:

 

[Erel]

You are asking about Basic4android, right? This is Basic4ppc subforum.

 

[a_carignan]

You are asking about Basic4android, right? This is Basic4ppc subforum.

Yes:signOops: