Keith Herold wrote:
Well that's kinda nifty!
Does the ATTACH lock the external file for as long as it is ATTACHed or only
when transactions are active?
If it is only locked during updates, this is probably the way I will do it,
since I can sacrifice a little bit of time for periodic writes to the DB
file.
The ATTACHed file is only locked for the duration of transactions
that involve the ATTACHed file. So if you have a transaction on
just the in-memory database (or on another ATTACHed database)
the ATTACHed file never gets locked.
--
D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
