We have a small app which uses jbpm v3. One of the things in the app is to list the tasks a user is assigned to. The task details such as client name, address are stored in variable called client. When the home page is being rendered, for each task, the client is read from database and task is displayed with a proper description. The problem is for 50 tasks the user has, getting the client object means hitting the database once which slows the app. It literally takes 30 seconds for some users... When I look at hibernate layer queries, I see a bunch of select statements for each task to get the client object.
Is there a way to speed up the jbpm so that variables are loaded more efficiently or in batch ? Doing it per task instance is simply not acceptable performance wise. Thanks.