james-server-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Danny Angus" <danny.an...@gmail.com>
Subject Re: Notes from ApacheCon
Date Mon, 31 Jul 2006 11:55:14 GMT
Appologies for late reply !


On 15/07/06, Noel J. Bergman <noel@devtech.com> 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: server-dev-unsubscribe@james.apache.org
For additional commands, e-mail: server-dev-help@james.apache.org


Mime
View raw message