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_at_nnrp1.deja.com>

Hello,theres
[Quoted] [Quoted]   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 [Quoted]   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.

---

[Quoted]   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 - 07:33:28 CEST