Performance Problem with jdbc and Oracle 8.1.6

From: Marc <marc.gellenbeck_at_solutionline.com>
Date: 18 Oct 2001 10:18:50 -0700
Message-ID: <85b14765.0110180918.5ba7da71@posting.google.com>

We have a problem with a JDBC - Application. Simply we start with a table consisting of a number and a varchar2(1500).

We fill this table with 200 rows (number is three-digit, varchar consists of a string with 30 characters). After that we start an application to read the numbers and varchars and measure the time it uses (number about 20 ms, varchar about 20 ms).
Then we drop the table, create it again and fill it with 200 rows: number 3-digit, varchar2 with 300 characters. The application now needs about 20ms for the number and about 2000(!)ms for the varchar.
If we increase afterwards the length of the String to 900 characters, we have got an elapsed-time of about 50 ms.

This result is given on the database server, on another server connecting to the database server, but not from an NT-Server.

Our specification is:
Sun Solaris 5.8; Oracle 8.1.6.1; Oracle jdbc-classes12 8.1.6 and 8.1.7 with jdk 1.2.2_07a or jdk 1.3_01

NT Server 2000; jdk 1.2.2; jdbc-classes12 8.1.7

Regards, Marc Received on Thu Oct 18 2001 - 12:18:50 CDT