Re: FIFO in Oracle

Check out the Oracle 8 white paper on advanced queueing... sounds like a perfect fit for your application.

Mr Michael Wai Kee Yung wrote:
>
> Dear all,
>
> Our company is going to develop an Oracle application that requires to
> store requests in a database table (let's name in DB Queue) and later on
> another server program will pick up the requests and process in a FIFO
> fashion.
>
> The question is how can I do it in Oracle efficiently. It seems to me the
> server need to read all the requests and sort by time stamp when every
> time the server program is free to do something.
>
> Of course a sort for each fetch is costly. We could create a share memory
> table and store, say 100 requests to the memory and the server process
> from there. Still, you know, it require a sort for every 100 requests.
>
> Any idea how our company can improve this mechanism ?
>
> Many thanks in advance.
>
> Cheers,
> Michael \\8-)
>
> --
> +----------------------------------------------------+
> | Born To Be Wired : http://www.hk.super.net/~myung/ |
> +----------------------------------------------------+
Received on Tue Feb 17 1998 - 00:00:00 CST