Re: alternative to using a sequence

On 8/26/06, snacktime <snacktime(at)gmail(dot)com> wrote:
> I have an application that processes financial transactions. Each of
> these transactions needs to be sent with a sequence number. It starts
> at 1 and resets to 1 once it hits 8000. I'm trying to think of the
> most elegant solution without having to create a sequence for each
> user (there are hundreds). There is a table that holds the
> configuration parameters for each merchant, so a field in that table
> to hold the sequence number would be ideal. In the past I've used
> sequences as well as just a field which I query then update. Any
> other ideas?

How many sequences are we talking about?

merlin