Multithreading Vs Multiple JVM's
843811Mar 20 2002 — edited Mar 21 2002Hi,
I'm having a performance issue regarding threads.
My application reads from the database (say 3000 records) for a request.
When I run 1 request the execution time for the request (both SQL execution and reading from DB)is 1 second
When I run 8 different JVM's on a solaris box having the same kind of request, the time spent for executing SQL and reading from Database is about 1.5 seconds
When I run 1 JVM and have 8 threads executing the request the execution time is about 3-4 seconds. The problem occurs while reading from the database (I think).
What can I do to minimize the execution time while running as a multithreaded process (bring down the execution time from 3 secs to atleast 1.5-2 secs).
I'm using JDK1.3.0, Solaris. I'm also using -server options and using lwp thread model.
I need a reply urgently...
If you do not understand the problem please let me know.