[yunqa.de] DISQLite: Pragma and VACUUM
- From: Gregory Whitesides <whitesidesg@xxxxxxxxx>
- To: yunqa@xxxxxxxxxxxxx
- Date: Thu, 24 Dec 2009 03:26:18 -0800 (PST)
Dear Ralf,
Please, what pragma should I use for VACUUM?
I need maximum optimization for speed.
Also, how to set temporary journal file on another hard disk?
Currently I use the following code:
FDB.Execute('PRAGMA synchronous=off;');
FDB.Execute('PRAGMA locking_mode=exclusive;');
FDB.Vacuum;
FDB.Execute('PRAGMA synchronous=normal;');
FDB.Execute('PRAGMA locking_mode=normal;');
{ Access the database to enable the new locking mode. }
FDB.Execute('SELECT 0 FROM ' + SQLITE_MASTER_QUOTED + ';');
Kindly regards,
Gregory
_______________________________________________
Delphi Inspiration mailing list
yunqa@xxxxxxxxxxxxx
//www.freelists.org/list/yunqa
Other related posts:
