If you are using WebSphere Process Server v6.0.2.1 and have processes involving human workflows (i.e. make use of the human task component) you may want to check out this document to see how you can tune the performance of these using a concept called materialised views.
Thanks to Ashok Iyengar for the pointer!