My money wouldn't be on that JDBC driver. We use SQL 7 drivers from this
company: www.inetsoftware.de
Other that that we use the same setup and have never had that problem.
James Wilson
HealthFirst Corp.
-----Original Message-----
From: A mailing list for discussion about Sun Microsystem's Java Servlet
API Technology. [mailto:[EMAIL PROTECTED]]On Behalf Of
Santosh.V
Sent: Friday, October 13, 2000 5:04 AM
To: [EMAIL PROTECTED]
Subject: [SERVLET-INTEREST] Perfomance issue
Help Required Ugently.
I have a servlet here which has a lot of SQL statements fired.
when Table size is small say a few hundered records, then program works fine
However when tha table size is of 13000 records then the server hangs
There is a process called JAVAW.exe which consumes 98% of CPU time
I have Set AutoCommit() to True.
My Run Time Environment is the following
1. IIS WebServer 3.0
2. JRUN 2.3.3
3. FREETDS JDBC DRIVER
4. jdk 2.0
5. MSSQL Server 7.0
6. WINDOWS NT 4.0
Can You Suggest some better Run time Envirionment or some method to improve
the Perofmance
What is JAVAW.exe doing with JRUN
Thanks
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
