[yunqa.de] Re: DISQLite: Pragma and VACUUM
- From: Gregory Whitesides <whitesidesg@xxxxxxxxx>
- To: yunqa@xxxxxxxxxxxxx
- Date: Thu, 24 Dec 2009 23:09:49 -0800 (PST)
--- On Thu, 12/24/09, Delphi Inspiration <delphi@xxxxxxxx> wrote:
> VACUUM is already optimized internally.
Thank you for explain it so well!
> >Also, how to set temporary journal file on another hard
> disk?
>
> This PRAGMA allows to adjust the directory where files used
> for storing temporary tables and indices are kept:
>
> PRAGMA temp_store_directory = 'directory-name';
Yes, thank you it works perfectly except for the temporary *.journal file that
was created together witn *.db and deleted after VACUUM. Is any way to adjust
directory for *.journal file?
Greg
_______________________________________________
Delphi Inspiration mailing list
yunqa@xxxxxxxxxxxxx
//www.freelists.org/list/yunqa
Other related posts:
