[yunqa.de] Re: Regular cleanup needed for SQLite databases?
- From: Edwin Yip <edwin.yip@xxxxxxxxxxxxxxxxxx>
- To: yunqa@xxxxxxxxxxxxx
- Date: Thu, 27 Jan 2011 16:47:31 +0800
Try the vacuum SQL command.
On Thu, Jan 27, 2011 at 4:25 PM, Tobias Rapp <t.rapp@xxxxxxxxxxxxx> wrote:
> Hello!
>
> I recently had the case that the MS Access database file of one program
> became "fragmented": It contained less than 5 rows but still was over 10
> Megabytes in file size and insert/delete of rows took more than 4 seconds.
> Finally it was necessary to replace the database file with a new, unused
> instance to get rid of the performance problems.
>
> I plan to change the database engine from MS Access to SQLite now. Is this
> something that can happen to (DI)SQLite database files, too? Do I need to
> regulary perform some clean-up maintenance on it? My application is running
> 24h/7days a week and using the database file for persistence of running
> jobs
> (that is amount of rows is low but amount of insert/update/deletes is
> high).
>
> Regards,
> Tobias
>
> _______________________________________________
> Delphi Inspiration mailing list
> yunqa@xxxxxxxxxxxxx
> //www.freelists.org/list/yunqa
>
>
>
>
--
Best Regards,
Edwin Yip
Mind Mapping is as Effortless as Typing
http://www.InnovationGear.com
Other related posts:
