Performance

The MFCPerf sample illustrates two things: tuning the MFC ODBC database classes for performance, and capturing and interpreting Microsoft® SQL Server™ ODBC driver performance data.

The sample uses advanced features of the MFC ODBC database classes and must be built with MFC version 4.2 or later. Although MFC is ODBC 2.x compliant, the MFCPerf sample uses features of the SQL Server ODBC driver available only in SQL Server version 7.0. The application must be built with ODBC 3.x header files and libraries.

The sample is an MFC MDI application that uses the Northwind sample database.

The application includes three documents. Two of the documents share a single view that displays customer order history. These documents are selected using the File\New Fast or File\New Slow menu items. One of the documents is identified as “slow.” It uses MFC filter strings to execute SELECT statements, retrieving data from the Northwind Orders and OrderDetails tables. The second document, identified as “fast,” uses parameterized execution of a SQL Server stored procedure to accomplish the same task.

The PerfTest menu, available when no document windows are open, automates creation of one of each document and steps through 20 client records. The process captures the SQL Server performance statistics for each document and displays them. The “fast” document shows a dramatic decrease in server roundtrips and a corresponding drop in data moved across the network.

Build Configurations

Mfcperf.mak contains nmake configurations for ANSI debug and release versions of the sample.

Build target CFG parameter Output directory
ANSI debug “MFCPerf - Win32 Debug” Debug
ANSI release “MFCPerf - Win32 Release” Release

Functions Illustrated
SQLAllocHandle SQLSetConnectAttr CRecordSet::Requery
SQLDataSources CDatabase::Open CRecordSet::MoveNext
SQLGetConnectAttr CRecordSet::Open CRecordSet::IsEOF

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.