S Smee Well-Known Member Licensed User Longtime User Feb 21, 2010 #1 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
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 Expert Licensed User Longtime User Feb 21, 2010 #2 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....
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 B4X founder Staff member Licensed User Longtime User Feb 21, 2010 #3 As Cableguy wrote you should use the VACUUM command: SQLite Query Language: VACUUM
a_carignan Member Licensed User Longtime User May 8, 2011 #5 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:
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 B4X founder Staff member Licensed User Longtime User May 8, 2011 #6 You are asking about Basic4android, right? This is Basic4ppc subforum.
a_carignan Member Licensed User Longtime User May 15, 2011 #7 Erel said: You are asking about Basic4android, right? This is Basic4ppc subforum. Click to expand... Yes:signOops:
Erel said: You are asking about Basic4android, right? This is Basic4ppc subforum. Click to expand... Yes:signOops: