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
>-----------------------------------------------------------------------

Verify that the OCI pgm is enabled to use array processing. Ken F.

-- 

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~