On Mon, 30 Jan 2006, Gerhard Häring wrote:
>[EMAIL PROTECTED] wrote:
>> "Dan Petitt" <[EMAIL PROTECTED]> wrote:
>>
>>>I think (looking at the source) that it's a pragma, but I don't know when
>>>you set it, once when DB is opened, on each write or on each read.
>>>
>>>You are the third to ask (including me), maybe Richard or someone else can
>>>through some light on it for us.
>>
>> READ UNCOMMITTED only works if you enable the shared cache
>> feature and have two or more database connections sharing the
>> same page and schema cache (meaning that they are both running
>> in the same thread). Documentation is forthcoming.
>
>I don't understand the point of this feature. In fact I don't know why I
>would want more than one database connection per thread at all. When
>would I need that?
I think the point is to use a single server thread to service multiple
database connections from other threads, via a queue or some such. Have a
look at server.c in the latest source for a sample implementation.
>
>-- Gerhard
>
Christian
--
/"\
\ / ASCII RIBBON CAMPAIGN - AGAINST HTML MAIL
X - AGAINST MS ATTACHMENTS
/ \
