Subject Re: [firebird-support] Re: Long table or many tables?
Author Alexandre Benson Smith
epedder wrote:
> Hello Lester,
>
>
> A good point but we need to be able to order results on those text fields. Though it may be worth benchmarking splitting the text fields into short VARCHARs for indexing with the rest in a BLOB.
>
>

You can just join the messages table with adressess table and order by
address, or even use a view to simplify everything...

> Thanks very much for your insight,
> - Elric
>

see you !

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