db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Knut Anders Hatlen <Knut.Hat...@Sun.COM>
Subject Re: Derby and string storage details
Date Mon, 10 Sep 2007 06:47:09 GMT
Daniel Noll <daniel@nuix.com> writes:

> Hi all.
> If I have 1,000 of the same string in a table for some reason, is the string 
> stored 1,000 times, or is it only stored once?

Hi Daniel,

It's stored 1000 times. If you need that space optimization, I think
you'll have to code it yourself with a separate string table and use
string identifiers instead of the real strings in the original table.

Knut Anders

View raw message