Robert martin wrote:

> Alexandre Benson Smith wrote:
>
>> I am not sure if I understood it well...
>>
>> But you could create a view to mimic a summary table, or even create a
>> table with details with another name, and create a view with the old
>> name of the table with just a sumary, you will have not to change a lot
>> of SQL.
>>
>> see you !
>>
>>
>>
> Hi
>
> I thought about a view but thought the performance might suffer. Will
> run some tests and see what the performance is like.
>
>

Using FB 2.X should give the same performance as a direct SQL statement,
FB 1.X moves the WHERE clause to a HAVING clause, what gives worse
performance than a direct SQL.

see you !

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