2 Replies Latest reply on Oct 8, 2013 11:15 AM by Mauricio Salatino

    Performance in table PARTICIPATION

    Marcos Sousa Newbie

      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.

       

      What type of archiving can be made to table participation?

       

      We a using SQL Server 2005 with JBPM 4.3