Home -> Usenet -> comp.databases.oracle -> Speed of stored procedures

Speed of stored procedures

From: pug <mpadfield_at_hotmail.com>
Date: 6 Feb 2002 08:09:21 -0800
Message-ID: <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 Wed Feb 06 2002 - 17:09:21 CET












Original text of this message