Sequence design question ~~

From: Chun-Yen <agi_at_haa.com.tw>
Date: Mon, 21 Aug 2000 05:33:28 GMT
Message-ID: <8nqev8$bnf$1@nnrp1.deja.com>

Hello,theres
We want to develop a forum system. There're lots of boards in each forum category. When a user post a message to a board, I want to keep the sequence for the post for each board. Therefore, I need lots of sequences. In my mind, I have three methods to choose,

meth1
Just do "SELECT MAX(seq) from msg_tab where boardid=100 FOR UPDATE", before I insert a message to msg_tab

meth2
create a trigger to dynamic generate sequence "seq_board_100" for further usage, therefore, I'll have lots of sequences.

meth3
create a sequence table seq_tab ( boardid number(4),max number(10)) each board corresponds to a record, whenever I post a message, update the max value for the board.

  Which one is better ??
  Any other ideas ??
  Do appreciate for any comments !!

Rgds,
Agi

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Aug 21 2000 - 00:33:28 CDT