OCIStmtFetch
From: Ray Campbell <raymond.campbell_at_primextrading.com>
Date: 4 Mar 2002 05:44:39 -0800
Message-ID: <2ce1e0eb.0203040544.1dcfbcbb_at_posting.google.com>
Date: 4 Mar 2002 05:44:39 -0800
Message-ID: <2ce1e0eb.0203040544.1dcfbcbb_at_posting.google.com>
I am using the OCI library. I found that the OCIStmtPrepare to be a little slow unless I set the attributes to not do a prefetch. But this in turn makes the OCIStmtFetch very slow. I debugged the application and took out the actual select statement and ran that in sqlplus. This statement runs approximately 4 times as fast as the OCIStmtFetch. Does anyone know why and how can I speed the fetch up?
Ray Received on Mon Mar 04 2002 - 14:44:39 CET