Re: Sequence Number Re-use is it possible, what is the standard

Just to make sure, you will get a better performance with cache specified and a large enough cache size.
Else you will see enqueue contention on the SQ enqueue (with the 200 users that you mentioned earlier).

Anjo.

u28656005_at_spawnkill.ip-mobilphone.net wrote:

> Thanks for the response.
>
> We are already using NOCache. I think we are just wondering if anyone has put
> the unused numbers into another table so the front-end can get it from there or
> the sequence number to not have big gaps.
>
> I also added functionality on the front-end to show a screen to ask them to
> save, if they haven't already, so it won't skip as much. I know that will help
> tremendously.
>
> However, when we get to some of our more complex systems, like our purcahsing
> system, it might need a more elegant solution.
>
> Thank you everyone who has replied so far.
>
> Mark
>
>
>
> --
> Spam protected message from:
> Sent by mspritzler from sasco within field com
> Posted via http://www.usenet-replayer.com/cgi/content/new
Received on Thu Mar 01 2001 - 23:42:42 CST