0 Replies Latest reply on Jan 28, 2008 3:38 AM by johan.parent

    Performance issue accessing process variables

    johan.parent

      Hi all,

      I run into a performance problem here. My app creates an inbox-like task list. To populate that list with relevant information I retrieve the process variables assoc'd with each of the tasks. Unfortunately this lookup takes around 40ms per task (cummulated time of all the required queries, on Sybase in WLS 8.1 setting). The time needed to display a list of 700 entries is inacceptable for our users.

      I have never played with hibernate. So I still use the config that came with jBPM. Any hibernate options I can explore or best pratices on code level?

      All pointers welcome!

      Johan