Re: Should I use max()

From: Dante <dnotari_at_my-dejanews.com>
Date: Mon, 10 May 1999 13:56:13 GMT
Message-ID: <7h6ohu$2en$1@nnrp1.deja.com>

Raymond,
I would not recommend that as the table should be locked until the fetched max(n)+1 is commited.

  You could
   use a sequence
    or
   create a different table which would hold your max.

     The application would read from the maxtable and increase
     it.

I recommend the use of a sequence

Regards
Dante
In article <01be9ae0$58a7db20$9e5b4cca_at_Raymond.gmw.com>, "Ray" <raymond_at_gmwgroup.com> wrote:
> Should I use max(n)+1 to assign a new seq. no. on a large table with
>100
> user environment?
> Any performance issue?
>
> Raymond
>

--== Sent via Deja.com http://www.deja.com/ ==-- ---Share what you know. Learn what you don't.--- Received on Mon May 10 1999 - 08:56:13 CDT