Hi,
As you all know, we have to store the full message at BAM side to 
support message lookup.
Storing the messages in BLOB/CLOB format and casting them again will 
cause huge performance hit. So our plan is to keep the message in text 
formatand allowing user to store up to 1MB.
These are the proposed columns in our new table.(BAM_MESSAGE_DATA Table?)

    * BAM_ID     -->PK
    * BAM_MESSAGE_ID -->FK
    * BAM_ACTIVITY_ID -->FK (?)
    * BAM_TIMESTAMP
    * BAM_DIRECTION-->(in/out)
    * BAM_MESSAGE
    * BAM_REMOTE_IP

Your thoughts are welcome..
Thanks.
-Ratha.

_______________________________________________
Carbon-dev mailing list
[email protected]
https://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev

Reply via email to