Good points. Just wanted to add that MTS will also pool ODBC connections which can cut down on the load on your database server and/or cut down on the overhead involved in opening and closing connections on the client as needed.
>This is the case if your using a Multi Use instancing InProc OLE Servers. VFP 6.0 supports Apartment Model threading and MTS support. This doesn't really help in scaling apps since the VFP runtime won't process multiple instances to execute simultaneously(as you have stated above). Actually MTS in all the MS hype does not provide server pooling. All it really does is load and unload servers as required relieving the client of this duty. MTS just makes it less complex to build n-tier apps with no real performance benfit. Server pooling really what is needed to build scalable apps.
>