Subject | Re: "Generators" via table data |
---|---|
Author | tdtappe |
Post date | 2007-01-29T10:19:34Z |
Hi Alan,
several clients asking for a new counter values (via table row data,
no real generators), one client gets several values in a row and the
others have to wait. Though every call for a new counter value starts
a separate transaction.
But when I think about it, it must be of course the "sleep" of the
other clients after having got a deadlock on the previous attempt.
Maybe I have to implement something like a sleep also after several
successful calls. So that others also get a chance to generate values.
Or, as I alreay mentioned in a previous post, I have to implement some
kind of queuing mechanism. But how would/should I do this?
--Heiko
> just remember that calls to generators (i.e. the resultant generatedvalue)
> is outside transaction control - the generation of values hasnothing to do
> with transactions - they are merely serialised responses to calls in aYes, I know. But I was looking for an explanation, why when there are
> queue.
several clients asking for a new counter values (via table row data,
no real generators), one client gets several values in a row and the
others have to wait. Though every call for a new counter value starts
a separate transaction.
But when I think about it, it must be of course the "sleep" of the
other clients after having got a deadlock on the previous attempt.
Maybe I have to implement something like a sleep also after several
successful calls. So that others also get a chance to generate values.
Or, as I alreay mentioned in a previous post, I have to implement some
kind of queuing mechanism. But how would/should I do this?
--Heiko