The BDE SQL profiler lets you measure and log the execution time of SQL queries or SQL stored procedures called through the Borland Database Engine (BDE).
General InformationGeneral Information
The execution speed of an SQL database application depends directly on the speed of SQL queries. The BDE SQL profiler times the execution of SQL queries and SQL stored procedures when commanded through the Borland Database Engine.
The profiler tracks calls to the CreateCursor and Prepare methods of the TQuery object and calls to the ExecProc and Prepare methods of the TStoredProc object (CreateCursor is called from the Open and ExecSQL methods).
After the profiling is over, the profiler reports what SQL queries were called in your application during the profiler run. For each query the profiler provides detailed information, for example, the query’s SQL expression and execution time. For information on profiling results and how to work with them, see BDE SQL Profiler Results.
Requirements
The BDE SQL profiler works with applications compiled with Borland Delphi 7.0, 2005 - 2007 and C++Builder 6.0, 2006.
The profiler does not support BDE.NET components. It ignores queries that are performed through BDE.NET and does not display information about them in the profiling results.
| Note: | If you use a computer that has several processors or a multiple-core processor (for example, dual-core CPU) and has Windows XP Service Pack 2, then you must install the Windows update #896256 in order for the profiler to be able to time your application correctly. The update is available on Microsoft’s web site: |