Hi All,
I am currently working on an app with an SQLite database. I am able to add images as blobs without any issues. However, upon removing an image from the database, I notice that the size of the database remains large. Is there a way to optimize (i.e., remove blank space, etc.) an SQLite database upon deletion/modification of data? The database needs to be compressed upon deletion.
In other development environments there are "optimize database" options, so what am I missing with LiveCode?
Thanks, and I am somewhat new to SQLite (having only "dabbled around with it" in the past)...
Best regards,
- Boo
Gulf Breeze, FL
[Solved] - Optimize SQLite Database after Deletion?
Moderators: FourthWorld, heatherlaine, Klaus, kevinmiller, robinmiller
-
- VIP Livecode Opensource Backer
- Posts: 348
- Joined: Sun Jul 03, 2011 2:04 am
- Location: Gulf Breeze, Florida
[Solved] - Optimize SQLite Database after Deletion?
Last edited by keithglong on Tue Aug 18, 2015 11:30 pm, edited 1 time in total.
-
- VIP Livecode Opensource Backer
- Posts: 348
- Joined: Sun Jul 03, 2011 2:04 am
- Location: Gulf Breeze, Florida
Re: Optimize SQLite Database after Deletion?
Solved! You can utilize the following command to optimize an SQLite database:
Best,
- Boo
Code: Select all
revExecuteSQL gDatabaseConnection, VACUUM
- Boo