JRun does use JAVAW.exe. I'm guessing (since I can't see your code) that your
queries are returning some pretty large result sets and you are consuming a lot
of resources due to working with 13,000 records. Try to let the backend database
(assuming the db is on another machine) perform as much of the heavy processing
as possible. If you can't do that, try to reduce the number of records you work
with. Maybe you can return 500 records, process them and then get the next 500
(and so on).
That's my best guess based on info provided.
Kwon Ekstrom <[EMAIL PROTECTED]>@JAVA.SUN.COM> on 10/13/2000 11:05:46 AM
Please respond to "A mailing list for discussion about Sun Microsystem's Java
Servlet API Technology." <[EMAIL PROTECTED]>
Sent by: "A mailing list for discussion about Sun Microsystem's Java Servlet
API Technology." <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
cc:
Subject: Re: Perfomance issue
It's my understanding that jrun loads javaw
----- Original Message -----
From: "Santosh.V" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, October 13, 2000 5:03 AM
Subject: 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
___________________________________________________________________________
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
