Subject Re: [firebird-support] Re: Long table or many tables?
Author Alexandre Benson Smith
Lester Caine wrote:
> One thought would be - is the message content in a large character field
> 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.
>

Bu we must remember that small BLOB's that fits on the page are stored
directly with the record...

--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br