Richard Klein wrote:
John Stanton wrote:
Using a single Sqlite connection for each database and holding the
connection open means that maximum effect is obtained from Sqlite's
cache.
>
Why is that? Is there a separate cache (I hope not!) for each connection?
Thanks,
- Richard (new to the group)
Yes, each connection has a cache. A lot of concurrent connections means
a lot of memory allocated to cache and potentially a lot of duplicated
cached items. See shared cache mode for relief.
Follow this thread for reasons why the approach above is not a valid
solution.
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
