Ran <[EMAIL PROTECTED]> wrote: > > I thought to solve this by attaching another database I will create > temporarily for each query, and to place the temporary tables in this > attached temporary database. This way, *I think*, my main database will be > locked shared (I will only select from it) and the temporary database will > be locked exclusively. So I will be able to run such queries complex in > parallel. >
Correct. By splitting up each table of a databae into a separate database file you can achieve table-level locking in SQLite. -- D. Richard Hipp <[EMAIL PROTECTED]> ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
