Hi Kevin, Thanks very much for taking the time, sorry for the dealy in response, I was on a trip.
Regarding the issue, it is accessing data from 2 tables which has around 35K rows using JOIN method. I made sure it has indexes and I have optimized the query. But unfortunately I don't know how to check the servlet/database performance. Is there any tool to do that? (sorry for my lack of experience). I am using POJO not servlet. Is it normal to take little longer when accessing from other parts of the world? Thanks very much. Simon Mathew --- In [email protected], "Kevin F. Benz" <kb...@...> wrote: > > Simon, you need to address the performance aspects and determine why the > servlet is taking so long. You should be seeing servlet performance well > below a second (unless you are navigating millions of rows) as I expect the > database access is killing you (although I have no real data at this point > on which to make that assumption). Remember, there are client-side timeouts > as well so you could increase the server timeout and have the client go > away. > > At this point, you need to take your queries and find out how long they are > taking in the database tools to see where to start looking. If the query > performance is acceptable given the database size, then you need to look at > recursion issues in your servlet. If the database performance is not > acceptable, then you need to look for race conditions, filters and indexing, > table scans, etc etc. > > K > On 6/5/09 10:57 PM, "Simon Mathew" <avara...@...> wrote: > > > > > > > > > > > > > I found out the reason for the below issue, it has to do something with max > > wait time, it was 10 seconds, when I increased to 20 seconds it started > > working fine. When accessing from out of country, it is still throwing the > > same error message, I think it is because it takes little longer to process > > which exceeds the maxwait time of 20 seconds. I tried to increase the > > maxwait > > to 50 seconds and for some reason it doesn't take it. It hangs the > > application. > > > > Can I get an example of the maxwait code which sets time higher than 50 > > seconds. I really appreciate your help. > > > > Thanks > > Simon > > > > --- In [email protected] <mailto:flexcoders%40yahoogroups.com> , > > "Simon Mathew" <avaran75@> wrote: > >> > > >> > Application works perfectly fine if one person use it at a time. I > >> > checked > >> the number of connection pool and it has the size of 100. I have spent too > >> much time without any result to figure this out. > >> > > >> > I am using Tomcat 6, Java for serverside script, MySQL for database, and > >> use BlazeDS with remote Object. > >> > > >> > I desparately need your help, it is a bug brought up after we implemented > >> the system. > >> > > >> > Thanks > >> > Simon Mathew > >> > > > > > > > > > > >> > > > > Kevin F. Benz > > kb...@... 425-785-7100 > > http://www.kbenz.com > > > > "We can't solve problems by using the same kind of thinking we used when we > > created them" - Albert Einstein > > >
