Hi, I came across one more situation in which have to open multiple DB in the same process, and document says We have to assign this value as soon as opening the DB to avoid the conflicts. I think it can be assign this before opening the DB also, Am I right?
If the path of temp_store_directory changes then there will be conflicts. If assigned path is same always then is there any side effects? ex: every time while opening the DB assign this valus to same path /mnt/tmp. Thanks.. Thanks and Regards Deepak Quoting Richard Hipp <drh at sqlite.org>: > On 5/13/15, Deepak Hegde <deepakk at allgosystems.com> wrote: >> I have gone through the document and it says, it is not thread safe. >> What if the same database is used in the multiple processes? >> Can we have actual database path and this temporary path same? >> > > process!=thread. It is perfectly safe to run PRAGMA > temp_store_directory and point it to the same directory on multiple > processes. It is perfectly safe to have temp_store_directory and the > main database directory be the same. > -- > D. Richard Hipp > drh at sqlite.org >
