Re: Oracle 8 Server/JDBC Performance

Hi Mark,
  Browse around the Oracle site, jdbc driver area. There was a white paper on performance for the thin client driver for Oracle 8i. I had also read in one of their other papers, that using OCI for the application is (or should be faster) than the thin client driver. I couldn't substantiate that claim since for my convenience, I just use the thin client. Sorry I can't be of more help, but there is info out there. Cindy

Mark Hennessy wrote:

> Hi. I am putting together a test database which contains a single table with
> 30 million items of data. (Each record is about 100 bytes, with an integer
> primary key). I need to be able to support between 50 and 100 reads to this
> table (search on integer primary key, which is indexed) per second.
>
> Can anyone tell me what kind of hardware I will need for this level of
> performance?
>
> I was thinking of initially testing on a Dual Processor NT machine (Dual
> Pentium II 450, 256 MB Memory, 7200 RPM Hard Drives) which will use Oracle
> 8. The test application will be a Java application using JDBC drivers,
> preferably Type 4. (Related question - does anyone have performance data for
> Oracle JDBC Drivers for Thin Type 4 vs Type 2). Any useful resources on
> performance figures of Oracle 8?
>
> Regards,
>
> Mark Hennessy
> WinVista Corp
Received on Mon Jul 12 1999 - 00:23:03 CDT