Asynchronous execution is supported for most functions that are largely executed on the data source, such as the functions to prepare and execute SQL statements, retrieve metadata, and fetch data. It is most useful when the task being executed on the data source takes a long time, such as a complex query against a large database. The MFC ODBC classes now use only synchronous processing. Two classes CAsyncDatabase and CAsyncRecordset provide support for asynchronous execution. This allows an application perform other tasks while a complex query is executing.
Usage is very simple.
The framework calls this member function to set initial options for the recordset or database. According to MFC documentation asynchronous processing slows performance. Corp. All Rights Reserved.