Hi Mark,

I use a single shared connection for all views and performance has been great. I'm running synchronously for these views (default).

As far as SPT, I created two methods and a property in my framework to handle this.

The first Method establishes the connection to the server and stores the connection handle to the connection property.

The second Method disconnects.

So when I run SPT I run the connection method, then use the connection handle in the SQLEXEC() and then close the connection using the disconnect method.

Peformance has been excellent for this too, as it takes no time at all to connect and disconnect. The other advantage to doing it this way is if you ever change passwords, database names, etc... on the server you only need to go to one place to change the properties.

Take Care