Idea to speed up multiple jdbc connections?

[Haitao Jiang]

Hi,

I would appreciate any help on this: I got approximate
same timing on following two:

case 1: create 1 jdbc connection and issue 4 queries
sequentially

case 2: create 4 jdbc connections and issue 4 queries
via 4 different threads at the same time

The timing is done around statement.execQuery(query),
so overhead of multithreading can be ignored.

I would think case 2 should be faster, but it was not.

Any idea?

Thanks a lot
PS: the mysqld server 4.1.1a is running with 16
threads 


	
		
__________________________________
Do you Yahoo!?
Friends.  Fun.  Try the all-new Yahoo! Messenger.
http://messenger.yahoo.com/