To demonstrate the use of the BDE SQL profiler, we will use a sample application, BDE_SQL, which is installed with AQTime.
|On Windows Vista and later, AQTime samples are located in the <Users>\Public\Documents\AQTime 8 Samples folder. On other operating systems, the samples reside in the <Documents and Settings>\All Users\Documents\AQTime 8 Samples folder.|
<AQTime Samples>\Unmanaged\BDE_SQL\Delphi - Borland Delphi
<AQTime Samples>\Unmanaged\BDE_SQL\BCB - Borland C++Builder
To profile this example with AQTime, do the following:
Compile BDE_SQL with debug information using the corresponding compiler. For detailed information on how to do this, see How AQTime Profilers Use Metadata and Debug Information.
Open the AQTime project for the sample application.
Select BDE SQL Profiler from the Profilers dropdown list on the Standard toolbar.
Select BDE SQL Profiler from the Profilers dropdown list displayed in the AQTime menu of Microsoft Visual Studio.
Select BDE SQL Profiler from the Current Profiler submenu displayed in the AQTime menu of Embarcadero RAD Studio.
Press Run on the Standard toolbar.
Select Run from Visual Studio’s AQTime menu, or press Visual Studio’s Run button while any of the AQTime panels are active.
Select Run With Profiling from Embarcadero RAD Studio’s AQTime menu.
The BDE_SQL sample application will be invoked. Press Execute All Queries in this application to execute SQL queries.
Close the sample application.
In the next step, we will review and analyze the profiling results.