Re: Messaging system tables desgin
Hi,
I think, one table with the state "box" is the better way, because in case of changeing the box you only need one simple UPDATE Statement. With more tables you have to INSERT into the new table und DELETE in the old in one transaction.
If you have a large number of messages you might have table "deleted" or an other archiving place for messages you don't need anymore.
Kind Regards
Frank
Subject
Written By
Posted
December 06, 2007 07:15AM
Re: Messaging system tables desgin
December 07, 2007 01:13AM
December 07, 2007 07:05AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.