-
1. Re: jbpm performance with sybase
ralfoeldi Feb 24, 2006 9:13 AM (in response to nsobti)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
desperate_user Mar 15, 2006 4:15 PM (in response to nsobti)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 Mar 17, 2006 4:47 AM (in response to nsobti)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 Mar 17, 2006 4:50 AM (in response to nsobti)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
desperate_user Mar 20, 2006 11:55 AM (in response to nsobti)"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