You should also attempt to avoid using the Refresh method for the Parameters collection of Command objects. While it may be a great convenience to have the application automatically build the parameter list, it comes at relatively high cost, especially in distributed environments. Although the manual parameter definition may require a great deal of coding, it will offer improved performance because the OLE DB provider does not need to make additional calls to the server to retrieve the parameter definitions.