Appologies for late reply !
On 15/07/06, Noel J. Bergman <[EMAIL PROTECTED]> wrote:
- Have a separate "messages", consisting of [key, blob]
yep.
- The blob (or clob, as appropriate) should be the last column of any record.
While this is enough for Derby other DB's gain more performance tuning flexibility if the CLOB is in a joined table with only two columns, CLOB and PK. I understand from our DBA's that Oracle can choose to save CLOBS to file and not use the DB storage if we do this. I gather that this is better for very big CLOBS, like perhaps an email with a BIG attachement. d. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
