Subject RE: [firebird-support] Stored Procedures ordering perfomance
look, if you order by string column (VARCHAR or so) and you are using
national charset then you may be in trouble as index may not be used.

-----Original Message-----
From: Adomas Urbanavicius [mailto:adomas@...]
Sent: 23. nóvember 2004 08:28
Subject: Re: [firebird-support] Stored Procedures ordering perfomance

Daniel Rail wrote:

>At November 22, 2004, 09:10, Adomas Urbanavicius wrote:
>>The point is , that procedure itself does more reads, than is
>>For example proc P1 :
>> After I called P1, apears dataset DP1 with count reads from
>>for example 100.000, and result rows =10;
>>If I wish to order it (select * from P1 order by xxx ), it should
>>dataset DP1, and reads should remain 100.000.
>>But instead it creates dataset DP2 , with reads > 250.000 !
>>This is the point, that stored procedure with order by clause
causes big
>>OVERHEAD, and there is no escape from that.
>Which tool are you suing to get these statistics?
>And, do you notice a difference in performance(time wise) between
>two(without looking at those numbers)?
>If I'm not mistaken, those statistic numbers that you are stating
>not returned by the server, but are calculated by the tool you are
Well, in time also there is difference, and tool I have used for
IBAdmin, DBWorkbench, EMS IB Manager (all results same)


Yahoo! Groups Sponsor
click here



Yahoo! Groups Links

* To visit your group on the web, go to:

* To unsubscribe from this group, send an email to:

* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <> .

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