Re: SEQUENCE tracking
Date: Sun, 24 Mar 2002 10:24:06 GMT
Message-ID: <aPhn8.104077$af7.56191_at_rwcrnsc53>
use advanced queuing.
Jim
"Eran Dvey-Aharon" <eran_at_prosight.com> wrote in message
news:ce3f1689.0203240204.5038600f_at_posting.google.com...
> Hi all !
>
> I have the following problem :
> Many processes/threads write into a common table, that I use as a
> messaging queue. I use sequences, and that way the writers don't block
> each other.
>
> I also have many readers. The readers should be able to read all the
> entries that they didn't read before.
>
> How can I accomplish that ?
> To those of you that don't understand the problem : if the reader
> reads messages 1,2,3,4,6,7,8 it can't assume that messages # 5 will
> never be written.
> It might be in the process of writing.
> I also don't want to add any locks to this scheme. The readers should
> read only the new committed messages, and the writers should be able
> to write without being blocked.
>
> Any ideas ?
>
> Eran
Received on Sun Mar 24 2002 - 11:24:06 CET