At 10:43 PM 15/08/2004 -0400, you wrote:

>Still wondering about this performance issue?
>
>
>
>
>
> > Don't think of a selectable stored procedure as a persistent database
>structure or a temporary table.
> > It isn't.
>
>
>
> >Use a view for this structure, not a stored procedure.
>
>
>
>"A special flavour are "selectable Stored Procedures" that can calculate
>data row by row in the server and can be used like a View or a "virtual
>table" from the client side, which is especially useful for reporting
>tasks"
>
>
>
>-- Firebird Facts 1.5.

It's quite true...selectable stored procedures designed to meet
extraordinary reporting or viewing requirements are brilliant, fast,
convenient, great encapsulation...but it doesn't say that it will be
practicable to define a stored procedure and then outer join to it in such
a way that it needs to do 9 million row fetches.

>Just going buy what I read.

...proving the truth of the saying "there is a medium in all things".

:-))

Did you try using a view instead?

/heLen