Use adExecuteNoRecords in the ADO Command Object to Boost Performance

If you need to execute a stored procedure from a Command object, and the stored procedure will not return any rows, you can boost performance of the Command object by setting the adExecuteNoRecords option. This tells the Command object to not ask for a returning rowset, which saves a little overhead and reduces memory usage.

Share the Post:
Share on facebook
Share on twitter
Share on linkedin

Overview

Recent Articles: