Subject | Re: [firebird-support] SQL Help |
---|---|
Author | Robert martin |
Post date | 2007-10-17T02:09:47Z |
Alexandre Benson Smith wrote:
I thought about a view but thought the performance might suffer. Will
run some tests and see what the performance is like.
Rob Martin
Software Engineer
phone +64 03 377 0495
fax +64 03 377 0496
web www.chreos.com
Wild Software Ltd
> I am not sure if I understood it well...Hi
>
> 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 !
>
>
I thought about a view but thought the performance might suffer. Will
run some tests and see what the performance is like.
Rob Martin
Software Engineer
phone +64 03 377 0495
fax +64 03 377 0496
web www.chreos.com
Wild Software Ltd