Hi all, Currently our database schema does not support referential integrity between the tables MB_CONTENT (which stores message contet) and MB_METADATA (which store message metadata). But message content with no related metadata is meaningless.
To address this problem, what we have done is deleting message content along with metadata. But if we have have a foreign key relationship between the two tables, we will be able to ensure that no message content will be left without metadata associated. Also, it will reduce the number of database calls that are made thus speeding up the process. Any comments? Thank you. -- Sasikala Kottegoda *Software Engineer* WSO2 Inc., http://wso2.com/ lean. enterprise. middleware Mobile: +94 774835928/712792401
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
