At 19:32 01/06/2007, you wrote:
>When you have a connection with multiple attached databases and the
>connection acquires an exclusive lock, does it always lock all attached
>databases or does it keep track of which databases require the lock? Does
>using separate databases and attaching them improve concurrency (by
>providing finer-grained locking)?
It locks all attached databases. No, it does not improve concurrency but i can
improve speed if database files are on more than one phisical disk. The sqlite
bottleneck is i/o access on most cases.
------------------------------------------------------------------------------------------------------------
Usuario de FreeBSD+Xfce, OpenOffice y muchos mas OSS.
Microsoft declara que el OSS viola 235 patentes. Por favor, DENUNCIAME.
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
