Re: Bad performance of HTTPServletResponse at Tomcat

Hi ,
Thanks a lot for your answers.
My servlet performs database queries and returns the answer to client.

I'm sure that it's not a DB problem since I see in the profiler that
execution time of DB queries doesn't change, and the time of writting
to OutputStream consistently grows.

In the beginning of the test with 1 user the division is 10/90 for DB
queries, and with 20 users it turns out to 80/20 to the writting to
OutputStream.

And as I said , it waits up to 40 seconds in the writting.
To my mind I need to tune Tomcat. It seems to me that the problem in
the account of descriptors that Tomcat can open , and the problem
occurs when it gets to the limit.

So if you know how to tune it , or you know the possible reason of the
problem please help me.

P.S. I would add a picture from the profiler that shows this problem,
but this forum doesn't allow to attache files.

Thanks in advance, Sasha

.

Relevant Pages

  • Re: Slow database
    ... Can you run a profiler and identify the queries / Procedures causing the ... Check the Queries are written in optimized way. ... If you have mutiple disk controllers in the server, ...
    (microsoft.public.sqlserver.tools)
  • Re: Bad performance of HTTPServletResponse at Tomcat
    ... > My servlet performs database queries and returns the answer to client. ... > execution time of DB queries doesn't change, and the time of writting ... > Thanks in advance, Sasha ... Can you post a small snippet of code which outlines your servlet logic. ...
    (comp.lang.java.programmer)
  • Re: SQL Server slows down after 1-2 hours
    ... I think the profiler was the "bad guy" in my setup. ... order to get some idea of which queries are heavy and which not. ... remain at this level (filling up the cache ?). ... > What version of SQL Server are you running? ...
    (microsoft.public.sqlserver.server)
  • URGENT!!! Locking timouts
    ... You can use the profiler but modify it to look at queries ... In the meanwhile try changing your timeout in SQL Server ...
    (microsoft.public.sqlserver.server)
  • RE: High CPU Usage
    ... Run profiler and see what queries are taking the longest and which ones are ... > This SQL is used as a reporting SQL Server and the ... What else I can do to resolve this sitation. ...
    (microsoft.public.sqlserver.programming)