--- Aviad Harell <[EMAIL PROTECTED]> wrote:
> Regarding only to select statements, is there a known limit of number of
> concurrent connections to Sqlite DB?
>
> What about concurrent connections to the same table in the sqlite DB?
In sqlite 3.4.2 and earlier, each connection - even to the same database -
requires its own distinct file descriptor. So you limited by the number of
file descriptors for your OS.
In sqlite 3.5 they've changed the design to share a single file descriptor
for all connections to the same database. Also, connections to the same
database in 3.5+ will share the same database page cache resulting in less
overall memory usage.
____________________________________________________________________________________
Fussy? Opinionated? Impossible to please? Perfect. Join Yahoo!'s user panel
and lay it on us. http://surveylink.yahoo.com/gmrs/yahoo_panel_invite.asp?a=7
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
