5 Replies Latest reply on Mar 20, 2006 11:55 AM by Bryan R

    jbpm performance with sybase

    Nidhi Sobti Newbie

      Hello,

      I am using jbpm with sybase, and noticed that it takes 3 times more time than with hsqldb. I was wondering what could be causing it. Is this expected?

      Thanks.

        • 1. Re: jbpm performance with sybase
          Rainer Alfoeldi Novice

          hsqldb is in memory.

          that just might have an effect. maybe. possibly. under certain cercumstances :-)

          actually if you only get a 200% hit your database seems quite fast.

          • 2. Re: jbpm performance with sybase
            Bryan R Newbie

            Hi. I'm new at usign jbpm with sybase and I would like to know why it takes 7 seconds to perform this code lines:

            ProcessInstance instance = session.getGraphSession().loadProcessInstance(processID);
            Iterator tmpT = instance.getTaskMgmtInstance().getTaskInstances().iterator();

            I only get 20 elements on the 'tmpT' iterator.

            Is there something I am missing to configure?

            Thanks

            • 3. Re: jbpm performance with sybase
              Koen Aers Master

              Turn on the Hibernate logging to see the created SQL statements and try to execute them in a SQL client to see what is causing the problem. Probably creating an index on one of the jBPM tables can improve the performance.

              Regards,
              Koen

              • 4. Re: jbpm performance with sybase
                Koen Aers Master

                Btw, may I ask you not to crosspost your problems. You had already an answer in a different thread. If we spend our time answering the same question in different threads, this means that other users don't get a chance of a response for their questions.

                Thanks,
                Koen

                • 5. Re: jbpm performance with sybase
                  Bryan R Newbie

                   

                  "koen.aers@jboss.com" wrote:
                  Btw, may I ask you not to crosspost your problems. You had already an answer in a different thread. If we spend our time answering the same question in different threads, this means that other users don't get a chance of a response for their questions.

                  Thanks,
                  Koen


                  Sorry Koen. I understand your point. It won't happen again :p.

                  I have already tried the SQL client thing and there was no problem with the performance. After that I created some indexes in the jbpm tables and got a slightly better performance :(.

                  Thank you again

                  dU