Subject | Re: [firebird-support] Re: Long table or many tables? |
---|---|
Author | Alexandre Benson Smith |
Post date | 2009-10-09T20:05:03Z |
Lester Caine wrote:
directly with the record...
--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br
> One thought would be - is the message content in a large character fieldBu we must remember that small BLOB's that fits on the page are stored
> or in a blob? keeping large text fields in blobs helps in these sorts of
> cases as the actual record can be a lot smaller, and more will fit on a
> 'page' in storage. You only need to access the 'content' once you have
> identified the header records.
>
directly with the record...
--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br