hi,
Mat Hosan wrote:
Thanks Rafal,
I do recall seeing a comment about needing to periodically clean
postgresql. Is there a nice way to do this without needing to shut
anything down?
You mean this:
http://www.postgresql.org/docs/view.php?version=7.3&idoc=1&file=routine-vacuuming.html
or
http://www.postgresql.org/docs/view.php?version=7.3&idoc=1&file=sql-vacuum.html
Rafal
As for the getter methods, I am calling them via the local interfaces
from within stateless session beans with BMP set. I guess there could
be some kind of caching issue but I'm not sure where to look. Any
thoughts?
Regards,
Mat.
[EMAIL PROTECTED] wrote:
hi,
Mat Hosan wrote:
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.
(1) I had the same problem with JBoss 3.0.6 and PostgreSQL 7.3.1
unter cygwin, but only after creating new entries in the DB wth CMP.
the problem was PostgreSQL. If You want check, if there the problem
is by PG, than start the db with -F option.
(2) Are you calling the getters from the client? is this the same VM?
Or are you calling your entity beans thru local interface from a
session bean?
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
Rafal
-------------------------------------------------------
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
