Compact SQLite database

Christian Langers chris at whitelotus.on-rev.com
Wed Dec 30 13:09:11 EST 2009


Hi Stewart,

this could answer your question : <http://www.sqlite.org/lang_vacuum.html>

try somthing like this (if needed) :

global gConID
put "VACUUM" into tSQL
get revdb_execute(gConID,tSQL)

Hope this helps,

Christian


On 30/12/09 17:42, RevList wrote:
> Is there a way to compact a SQLite database from within a Rev application?
> I have an application that uses a SQLIte database and it grows in size as
> records are added.  The nature of the application is that the database is
> often purged but the db size does not reduce.  I can use a SQLite Manager
> application to compact the database, but I would rather do this within the
> application when the database is purged.
>
> Thanks in advance.
>
> Stewart Lynch
>
> --------------------------------------------------------------------------------------------------------------------
> This message and any attachments are intended only for the use of the
> individual to whom they are addressed and it may contain information that
> is privileged or confidential. If you have received this communication by
> mistake, please notify us immediately.
> --------------------------------------------------------------------------------------------------------------------
>
> _______________________________________________
> use-revolution mailing list
> use-revolution at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-revolution
>    




More information about the Use-livecode mailing list