Re: Help! JDBC / Oracle 8.05 connections open VERY SLOW

From: <seetharaman.n_at_usa.net>
Date: Fri, 10 Dec 1999 22:51:21 GMT
Message-ID: <82s058$kmc$1@nnrp1.deja.com>

Hi,

I have a different version from the previous email. The performance is poor not for creating connections but for retreiving data. I tried porting an existing ProC library to Java, and i found the times for retreiving data was around 3-4 times worse than with ProC. Pathetic, to say the least.

The following results were with the ported code, using JDK1.2.2 and JDBC 2.0 thin drivers for Oracle 8.1.6
(time in milliseconds)

Connect	Open_databank	Getseries	Close_databank	Disconnect
2644 	10 	        761/440/471/260/721	10 	31
230 	10 	        360/221/1432/220/421	10 	10
210 	20	        341/210/310/201/420	0	10
281 	10	        360/230/311/190/371	0	10
210 	10	        331/190/380/191/400	0	10
231 	0	        330/200/311/180/361	10	10
220 	10	        390/191/330/211/390	20	10
230 	10	        361/190/311/250/371	10	10
230 	10	        320/181/290/180/371	0	20
220 	0	        391/180/280/181/380	0	10

(Getseries is the function that retreives data; here, in each of 10
loops, it is called with 5 different sets of data)

The performance for Getseries with JDBC Thin driver was 3-4 times slower than with the JNI port. The other functions were of the same turnaround time.

The following results were with the ported code, using JDK1.1.7A (from Visual Cafe) and JDBC OCI drivers for Oracle 8.1.5

Connect Open_databank Getseries Close_databank Disconnect 4046 50 1643/270/441/280/1642/ 10 41

360 10 310/171/270/210/321/ 0 10
240 10 361/270/311/190/420/ 0 11
270 10 310/211/290/190/331/ 10 30
240 10 321/170/250/181/360/ 0 10
230 10 481/170/251/200/351/ 0 10
220 10 300/181/320/160/331/ 0 10
220 10 281/210/260/161/380/ 10 20
271 40 380/180/271/180/391/ 0 20
220 10 300/181/280/220/311/ 0 10

The performance is similar to the one with thin drivers.

The performance with JNI/ProC code is definitely better.

Connect	Open_databank	Getseries	Close_databank	Disconnect
801	30	        360/121/310/150/341	10	10
320	0	       100/60/91/60/100	        20	10
330	10	       111/60/80/60/100	        10	20
310	10	       101/50/90/60/100	        0	0
331	10	       100/70/90/60/100	        10	10
321	20	       100/60/80/60/100	        10	10
321	10	       100/60/90/50/100	        0	10
321	10	       250/60/80/50/111	        0	0
340	10	       240/61/90/60/100	       10	10
320	10	       101/60/80/60/100	       10	20

Could anyone point out why JDBC drivers are so slow? And how many of you are using JDBC for all those heavy traffic web sites?? :)

situ

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Dec 10 1999 - 16:51:21 CST