[JBoss-user] Performance Degredation Problem

[Mat Hosan]

Hi All,

I have a heavily transactional app running on JBoss 3.0.6 with Postresql 7.2.1 and have run into a performance snag. The whole application slows down over time. It appears that either (1) database access or (2) calling getXXX() methods on CMP entity beans is where this problem occurs.

The problem is apparently not related to database size. Even if I remove records after I finish with them everything still gradually slows down.

I sped things up initially by changing many of the db reads from Ejb.getXXX() calls to direct SQL queries. (The commit option is set to B for all CMP entity beans - I figured the database should be up to date enough for our needs)

I have played around with the connection pool size. Reducing the MaxSize
slows things down, but increasing it above about 50 doesn't appear to help.

I can't really do without the transactions because there is a whole lot
of concurrent stuff going on.

Does this sound like a familiar problem and are there any other tweaks that I could do to address this? Also can anyone point me in the direction of threads that discuss performance tuning for things like this. I must be seaching with the wrong keywords.

Thanks,
Mat




-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user