[Gpephone-devel] problem about sqlite database in english

[余民]

Hi,

There are some problems when we used the sqlite database.

1 Normally, when a transaction that deletes data from a database is
committed, the database file remains the same size. But I must to reclaim
the unused space. In this mode the "vacuum" command can reclaim unused
space. However the command consumed long time in the embedded machine.

The end users can not endure the long time waiting, so, how can I handle the
problem  ?


2 The database file may crash, in which case how can I do  ?


Thanks & BR

ym
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.linuxtogo.org/pipermail/gpephone-devel/attachments/20070509/0ee611d6/attachment.htm