Slow Lombardi Process Designer

During development time the Process Designer makes many queries to LSW_ENV_VAR.
This table is not large, however, one of the queries used by PD has a sub-query against LSW_PO_VERSIONS

This article (http://www-01.ibm.com/support/docview.wss?uid=swg21610258
) describes adding a few indexes to LSW_PO_VERSIONS and it worked a treat.

This other article (http://www-01.ibm.com/support/docview.wss?uid=swg1IC82730) was a little more involved and we didn't try it.. but worth a mention.

How to trick Process Designer into connecting to a Process Server that you have not registered

There might on occasion, be the need to connect your Process Designer to a Process Server that is not registered with the Process Centre that your PD's eclipse.ini is pointing at. Let's say for example that you need to give your developers access to a Process Server for debugging purposes only but you do not want them to be able to deploy to it.

The answer is fairly straight forward, you simply insert a row in the Process Centre's LSW_SERVER and LSW_SERVER_CAPABILITY tables that relates to the said Process Server making sure that you set its IS AVAILABLE column to false. Once this is done you'll notice that the Process Centre will have a new (albeit unavailable) Process Server in it's Servers list. 

Now, when and Process Designer instances are connected to the said Process Centre, they will be able to connect to the new Process Server via the drop down list in the Process Inspector screen.