Delay in the Results of a TSQLStoredProc.

[ftaveras]

Hi.

I am experiencing a delay in time to obtain the results of a Stored Procedure (TSQLStoredProc) with respect to time to carry the same "SELECT" using a TSQLQuery. "

Using a Test program PL / SQL directly:

a. Stored Procedure
begin
declare
cv_1 sys_refcursor;
begin
sp_test_result(cv_1=>cv_1);
end;
--print :cv_1;
end;

b. Query
select 1
from dual;

Result : The result is presented in 0.15 seconds in both cases.

2. Test Using dbExpress (Rad Studio 2007).
a. Assign the procedure to a Component TSQLStoredProc: Open.
b. Assign the "SELECT" to a component TQuery: Open;
Result:The response time of StoredProcedure is 10-12 times bigger than the Query.

[ftaveras]

The procedure:

create procedure sp_test_result(
cv_1 in out sys_refcursor
)as
begin
open cv_1 for
select 1 query_result
from dual;
end;
/

[Plash]

When you use TSQLStoredProc component, additional queries are performed to describe parameters of the stored procedure. To avoid these additional queries, use TSQLQuery component with a PL/SQL block.