[jboss-user] [jBPM] - Performance in table PARTICIPATION

[Marcos Sousa]

Marcos Sousa [https://community.jboss.org/people/marcos.sousa] created the discussion

"Performance in table PARTICIPATION"

To view the discussion, visit: https://community.jboss.org/message/778192#778192

--------------------------------------------------------------
I discovered that my *production environment*, tables.


PARTICIPATION has 1.373.344 KB with 14.848.703 rows
TASK          has 104.968 KB with 207.575 rows

*TaskServiceImpl.findGroupTasks* is very slow.

To resolve this issue I just *created an index* 
CREATE NONCLUSTERED INDEX [IDX_PART_GROUP] ON [dbo].[JBPM4_PARTICIPATION] 
(
    [GROUPID_] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]

*Is it normal an participation table with 15 milions of rows?*
If the answer is yes, so it is better to have this index in JBPM4 script.

We a using SQL Server 2005 with JBPM 4.3
--------------------------------------------------------------

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

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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20121124/899817e1/attachment.html