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?