SQLite: Difference between revisions

2 bytes removed ,  4 years ago
no edit summary
No edit summary
No edit summary
Line 6: Line 6:


<!--T:2-->
<!--T:2-->
Like any other database, an SQLlite database should not be used on a shared filesystem such as home, scratch and project. Typically, you should copy your SQLite file to the local scratch <tt>$SLURM_TMPDIR</tt> space at the beginning of a job where you can then use the database without any issues and also enjoy the best possible performance. Note that SQLite is not intended for use with multiple threads or processes writing concurrently to the database; for this you should consider a [[Database_servers | client/server solution]].  
Like any other database, an SQLlite database should not be used on a shared filesystem such as home, scratch and project. Typically, you should copy your SQLite file to the local scratch <tt>$SLURM_TMPDIR</tt> space at the beginning of a job and you can then use the database without any issues and also enjoy the best possible performance. Note that SQLite is not intended for use with multiple threads or processes writing concurrently to the database; for this you should consider a [[Database_servers | client/server solution]].  


==Using SQLite directly== <!--T:3-->
==Using SQLite directly== <!--T:3-->
rsnt_translations
56,563

edits