Pro host arrays

From: <nandagopalj_at_hotmail.com>
Date: Tue, 10 Aug 1999 23:53:05 GMT
Message-ID: <7oqe0t$6br$1@nnrp1.deja.com>

Hello:

I have been using the host arrays using Pro-C/C++ for my C++ application to access data from oracle database. The data being processed is in the order of 2.7 million records. To improve performance I have been using 5000 as the host array size for select statement. This causes oracle to respond when it is ready with 5000 records at a time.

Is there a optimum size for host arrays to maximize performance? Any info is appreciated.

Thanks
Nan.

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Tue Aug 10 1999 - 18:53:05 CDT