Re: OCI performance mistery

In article <30F0156E.4F4F61EE_at_lvalue.com>, vlads_at_lvalue.com says...
>
>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
>-----------------------------------------------------------------------
I've used OCI for sometime now- on windows 3.1, Windows NT and VMS 5.5. Never experienced your problem. I've now using non-blocking OCI calls as well. I'd like to look at your example so I can evaluate your problem. Received on Sat Jan 13 1996 - 00:00:00 CET