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.



Just going buy what I read.



-kurt





_____

From: Helen Borrie [mailto:helebor@...]
Sent: Saturday, August 14, 2004 10:54 AM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Firebird has MAJOR performance issues



At 01:09 PM 14/08/2004 +0000, you wrote:

>Hello,
>
>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.

/heLen





Yahoo! Groups Sponsor

ADVERTISEMENT
click here
<http://us.ard.yahoo.com/SIG=129an6lef/M=298184.5285298.6392945.3001176/
D=groups/S=1705115386:HM/EXP=1092581645/A=2164331/R=0/SIG=11eaelai9/*htt
p:/www.netflix.com/Default?mqso=60183351>


<http://us.adserver.yahoo.com/l?M=298184.5285298.6392945.3001176/D=group
s/S=:HM/A=2164331/rand=723243276>



_____

Yahoo! Groups Links

* To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

* To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com
<mailto:firebird-support-unsubscribe@yahoogroups.com?subject=Unsubscribe

>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .



[Non-text portions of this message have been removed]