4 Replies Latest reply on May 24, 2017 7:11 AM by rupeshbende

    Archiving Data in JBPM tables

    azegarek
    azegarek Aug 24, 2011 4:34 PM

      Hi-


      We are running JBPM 3 as part of a content management platform,  using MySQL as the underlying DB,  We are starting to suffer some performance issues which I believe are mainly due to table bloat in the underlying JBPM tables (primarily JBPM_VARIABLEINSTNACE - it has > 7M rows).

       

      We have developed the attached stored procedure in MySQL.  Can anyone comment if they believe this is 'safe', of if there is another approach to groom out data from JBPM tables once a process instance is complete?

      • 2742 Views
      • Categories: jBPM 3.0, jBPM 3.1, jBPM 3.2
      • Tags:
        • 1. Re: Archiving Data in JBPM tables
          salaboy21
          salaboy21 Aug 24, 2011 5:23 PM (in response to azegarek)

          Yes, in my opinion a store procedure is the best option for archiving old data that is not needed anymore.

          Cheers

            • Actions
          • 2. Re: Archiving Data in JBPM tables
            azegarek
            azegarek Aug 25, 2011 9:41 AM (in response to salaboy21)

            Thanks Mauricio-

             

            Wondering if anyone else has run up against the same thing and implemented purging for completed processes?

              • Actions
            • 3. Re: Archiving Data in JBPM tables
              eschabell
              eschabell Aug 25, 2011 10:24 AM (in response to azegarek)

              Hi Art,

               

              It is standard functionality in jBPM3 that all completed processes (history information) remains in the database. It is stated in the docs (enterprise docs) that you need to decide within your organization what you want to do with this, something like this:

               

              - don't care about old history, just remove/delete.

              - have BAM reporting in place so have to keep, then migrate out to a different format/location/db to allow for continued reporting.

              - apply enterprise process (for example, I worked in an enterprise that applied data warehousing techniques) to collect and store for reporting all history data

              - leave it in place, but be prepared to eventually have to enlarge your DB machine! ;-)

               

              That about covers it. I looked at your doc, but I am not sure anymore exactly what you all can clean out of your tables.

               

              Regards, erics

                • Actions
              • 4. Re: Archiving Data in JBPM tables
                rupeshbende
                rupeshbende May 24, 2017 7:11 AM (in response to azegarek)

                Hi,

                     We are planning to use jbpm for financial transaction. And volume of these transaction is large. So time to time we need to archive data of jbpm tables. Is there any build in fuctionality for archiving? If not what should be the safest approach to archive data? We are using jbpm6.5.  Please help

                  • Actions