Re: OCI performance mistery

Vladimir Stavitsky <vlads_at_lvalue.com> wrote:

>Hi, everybody.
 

>I am new to oracle - i used sybase for many years. The problem
>i am experiencing is related to OCI access to oracle; we have a very
>simple and rather small table - just 8 columns (datatypes NUMBER,
>DATE and VARCHAR2). The table is just 2,000 rows. The table does
>not have indexes, though, since no column is a key (or any column
>can be a key).
 

>Anyway, when i run sqlplus against this table, the responce time
>for a simple query (no join here) is wery short, the rows come
>almost immediately, which is expected. But when i run our application,
>which does the same exact query through OCI - it might take up to
>30 sec for the same query, which is ridiculous.
 

>I would appreciate any hint - i am quite sure we are doing something
>deadly wrong.
>--
>-----------------------------------------------------------------------
> ... occurrences like this will be few and far between ...
 

>vlad_at_dkbfpny.com Vlad Stavitsky vlads_at_lvalue.com
>-----------------------------------------------------------------------

Are you using array fetching in your oci program? By default, SqlPus fetches 15 rows at a time.

sm Received on Mon Jan 08 1996 - 00:00:00 CET