Client/Server Tuning

You can tune your client/server.

The following sections include tips for client/server tuning:

• Diagnose Client/Server Performance

• Work Locally When Possible

• Choose Timeout Connection Attributes for Your Client

• Choose a Lock Wait Timeout interval

• Choose the Best Method of Locking

• Enable Prefetch Close for Read-Only Transactions

• Use a Connection Handle When Calling SQLTransact

• Enable Multi-Threaded Mode to Handle Concurrent Connections