John Stanton <[EMAIL PROTECTED]> wrote:
>
> 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.
>
Yes. But remember that shared cache mode has limitations:
* When shared cache mode is enabled, you cannot use
a connection in a thread other than the thread in which
it was originally created.
* Only connections opened in the same thread share a cache.
The shared cache mode is designed for building a "server thread"
that accepts connection requests and SQL statements via messages
from "client threads", acts upon those requests, and returns the
result.
--
D. Richard Hipp <[EMAIL PROTECTED]>
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
