Subject Re: [firebird-support] Firebird has MAJOR performance issues
Author Helen Borrie
At 01:09 PM 14/08/2004 +0000, you wrote:
>I'm wondering if I'm posting this to the correct group? It seems that
>either I'm asking a question that is too difficult to answer

..or too lengthy to answer...

>or this
>group does not want to annie up to the fact that Firebird does have
>major performance issues that the main stream databases (even MS
>Access) have figured out.

...or you just got it wrong.

>I thought I included enough information to help this group diagnose
>the problem, but I could be wrong.

Short answer, you included enough information. Don't think of a selectable
stored procedure as a persistent database structure or a temporary table.
It isn't. It's one row at a time output to a buffer. Once the row has
been fetched by the caller (in this case, the query engine) it is discarded
and the caller then asks for the next row. So go figure how this behaves
in an outer join and how you triggered off 9 million fetches for a join
that had 7000 actual matches.

Use a view for this structure, not a stored procedure.