marco angheben [http://community.jboss.org/people/marco.angheben.2] created the 
discussion

"Performance problems due to too many users registered?"

To view the discussion, visit: http://community.jboss.org/message/581833#581833

--------------------------------------------------------------
Hi all.
We are running a JBoss Portal 2.6.4 instance on an Oracle 10g database, and we 
are experiencing a lot of performance problems related to OutOfMemoryError and 
CPU saturation; in addition to this, the system is extremely slow when 
accessing the pages for user management in the Admin portal.
Looking at the JBPM tables i found out that for each user registered existed a 
record in the JBPM_PROCESSINSTANCE table, with the END_field filled with the 
time the user had became active on the Portal.
As extreme try to solve our problems we deleted all the ended process instances 
associated to the jbp_identity_validation_approval_workflow using the JBPM API 
to avoid encountering problems on the database constraints. This cleaning 
operation seems to solve all the problems we had, as you can see looking the 
image attached.
Has anyone experienced a problem like this? Does anyone think a clean-up 
procedure like the one described above will be effective and harmless?
--------------------------------------------------------------

Reply to this message by going to Community
[http://community.jboss.org/message/581833#581833]

Start a new discussion in JBoss Portal at Community
[http://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2011]

_______________________________________________
jboss-user mailing list
jboss-user@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/jboss-user

Reply via email to