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&...]