Re: Speed of stored procedures
Date: Thu, 07 Feb 2002 06:18:09 GMT
Message-ID: <B_o88.4783$bh3.83853_at_rwcrnsc52.ops.asp.att.net>
Read the oo4o performance section. You should try to open the cursor once
and reexecute (refresh) it many times. Also use parameters and just change
the parameter value and refresh the query. You will finf that that works
very fast.
Jim
"pug" <mpadfield_at_hotmail.com> wrote in message
news:7ecab58b.0202060809.23fda412_at_posting.google.com...
> I have a program that uses a database as a reference database to check
> whether codes in records exist. So they are very simple select * from
> table etc queries. I have been using stored procedures in SQL server
> 7 with ADO from a VB6 program. I was asked to do it with oracle as
> the database and the stored procedures are much slower than sending
> straight SQL I have tried using OO4O and i get the same the straight
> uncompiled SQL comes back quicker than than the stored procedures.
> Both options are slower than with SQL server version. Any
> suggestions. All the oracle tables have the same indices. The stored
> procedures in the oracle database are packaged so as to return a
> recordset.
Received on Thu Feb 07 2002 - 07:18:09 CET