-----Ursprüngliche Nachricht-----
Von: Helen Borrie <helebor@...>

>>But what about performance?
>>How fast is a subquery compared with an iterative
>>loop in a stored procedure?
>... I find anything using subqueries to be a very slow way
>to fill a column in a dataset. But, in the case where you are fetching a
>tiny dataset, it could be cheaper. Why not try it out and let us know the
>difference? Don't forget - I'm trawling for wisdom like this for the
>Gotchas section of the IBDH.

ok, I´ll go and measure it and send you results.
but I´m still using IB5.6 so I will repeat the test when official
IB6 is released.

hannes hernler
--------------------------------------------------------
DWS - Delphi Web Script
developing professional web apps
look at http://www.dwscript.com
--------------------------------------------------------