Re: [sqlite] Different temp_store_directory settings okay?

2010-03-04 Thread D. Richard Hipp
On Mar 4, 2010, at 4:30 PM, Brian Dantes wrote: > D. Richard Hipp wrote: > >> It is OK for different processes to use different >> temp_store_directory > >> settings. The temp_store_directory is only used for TEMP tables. It > >> does not play a roll in the persistent state of the database.

Re: [sqlite] Different temp_store_directory settings okay?

2010-03-04 Thread Brian Dantes
D. Richard Hipp wrote: > It is OK for different processes to use different temp_store_directory > settings. The temp_store_directory is only used for TEMP tables. It > does not play a roll in the persistent state of the database. I was worried because of this statement in the docs: "When

Re: [sqlite] Different temp_store_directory settings okay?

2010-03-04 Thread D. Richard Hipp
On Mar 4, 2010, at 4:10 PM, Brian Dantes wrote: > Is it okay for two different *processes* using > independent connections to the same database two > have different values for the temp_store_directory > pragma? > > The docs make it clear this is not okay for two > *threads* in the same process