Tell us which Firebird version you are using, and show us the stored procedure (or a part of it that demonstrates the problem). Then we might be able to show alternative solutions.

HTH,
Set

-----Original Message-----
From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] On Behalf Of hfsnell
Sent: 13. oktober 2008 12:45
To: firebird-support@yahoogroups.com
Subject: [firebird-support] How a stored procedure exectute?

Dear experts!
I supposed that a stored procedure execute and return a temporary
table. However, I am wrong! When I execute the following SQL:
select * from mysp();
it costs about 1 second.
select * from mysp() where t=100
it costs about 1 second
but
select * from mysp() where t=110
it costs 4 second.
I try many times and get same results.
I use IBExpert to make analysis, I found that the number of indices
read when the stored procedure executes are differnts at last two cases.
Please help me!
Thanks!