Hi Sasikala, Since we dropped cassandra, this will enable us to use full power of RDBMS. But make sure that mentioned operations will work on MySQL, MS SQL and oracle in the same way.
Thanks, Anuja On Fri, Jun 26, 2015 at 2:56 PM, Sasikala Kottegoda <[email protected]> wrote: > 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 > > -- Anuja Herath *Software Engineer* *WSO2, Inc.* Mobile : +94 (0)71 429 8861
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
