John,

CursorLocation set to 2 (AdUseServer) with Execute method, 44.43 seconds
CursorLocation set to 3 (AdUseClient) with Execute method, 136.4 seconds.

CursorLocation set to 2 (AdUseServer) with Recordset method, 45.56 seconds.
CursorLocation set to 3 (AdUseServer) with Recordset method, 136.73 seconds.

w/o specifying CursorLocation (default), with Execute method, 76.83 seconds.
w/o specifying CursorLocation (default), with Recordset method, 91.10 seconds.

My concern so far with ADO, is that I find it hard to trap every error that occurs in VFP because it gives me its native error message and it causes the entire app to close. Unlike SPT, it returns 1,0,-1 which is very easy to trap in code and code management is seamless.

I didn't know about ADO before until I learned VB. With DE in VB, ADO shape is awesome because you do it visually.

With the significant advantage of ADO over SPT, I am quite pressured to convert our SPT intensive app which we based it on RobertG's 3tier Technical Reference.

Any further advise is highly appreciated.