Getting results from oracle query suck!

I have a table that contains customer name information (about 10 fields). There are about 1.9 million rows in the table. The table is index by the last name. I am writing application code in both C++ using oracle oci and java using again the supplied oracle oci drivers (see oracle web site). In a test program I am timing the execution of the select statment and then timing how long it takes to 'read' (or drain) the rows of data from the database. The timing results are as follows:

Rows in Result Set      Query Time (ms)   Read results time (ms)
2824                             187                            11875
211                               156                                969
1330                             187                              4984
1740                               78                              6062

The test program was run on both a workstation using net8 and locally on the server that is running the database using a local connection (no network involved) and the results were similiar.

The server is a 2 way 200 mhz intell box with 512 meg ram 80 gig hd space. Can someone please explain some areas that I can look at in order to improve the performance of reading the result set?

Thanks
-mike Received on Tue May 04 1999 - 09:55:23 CDT