X-Cart:X-Cart Benchmark report tool

A built-in tool for the measurement of the time of code execution is available in X-Cart starting with X-Cart version 4.1.x. For X-Cart 4.0.x versions, a special patch is available to get this tool.

Time measurements are based on the following control points:

• in the beginning of script execution (in top.inc.php);
• in db_query() - before making an SQL-request and after it;
• in the function func_display;
• in the end of script execution (a function __debug() is created and registered via register_shutdown_function).

That way, the following measurements are performed:

• duration of time between two consecutive control points;
• total time for the execution of all the SQL requests;
• time of PHP code execution without Smarty;
• Smarty operation time;
• total script execution time.

The Benchmark tool can be enabled and configured using the following constants in the file top.inc.php:

• BENCH - whether the tool is enabled or not.

• BENCH_SIMPLE - perform measurements, but not display the results - only write the results to the binary log (if the BENCH_BLOCK_SAVE_BIN constant is disabled).

• BENCH_BACKTRACE - show backtrace information (The information is displayed when hovering the mouse cursor over a record number in the Benchmark report. This feature is not available in Firefox).

• BENCH_LOG_SUMMARY - write general performance information to .log file.

• BENCH_LOG_TIME_LIMIT - sets a limit (in seconds) defining which records should be written to log file. If the duration of the time period pertaining to a record exceeds the limit set by this constant, it will be written to log.

• BENCH_LOG_TYPE_LIMIT - limits the type of records that can be written to log. The allowed types should be entered as a comma-separated list like so: PHP, SMARTY, SQL.

• BENCH_DISPLAY_TYPE - report type (will be shown at the bottom of the page: T - only the totals; F - full (totals + report); A - advanced (includes the result of the EXPLAIN command for SQL-requests).

• BENCH_TIME_LIMIT - sets a limit (in seconds) defining which records should be displayed at the bottom of the page. If the duration of the time period pertaining to a record exceeds the limit set by this constant, it will be shown in the report.

• BENCH_MEM_LIMIT - sets a limit (in megabytes) defining which records should be displayed at the bottom of the page. If a record shows a memory use increase exceeding the limit set by this constant, it will be shown in the report.

The measurement results are output onto the screen in the form of a table (the output code comes in the __debug function). The format is as follows:

#	Index of execution of a control point in order
Time	Time period between the execution of the current control point and the following one
Memory	Memory use dynamics from the current control point to the following one
Label	Label (for example, an SQL request)

Example:

FULL TIME: 3.1977
Start time: 08/11/2005 17:48:20
Start memory: 0.132

#	Time	Memory	Label
1	0.1786	4.521	-
2	4.521	0.002	SELECT name, value, category FROM xcart_config
3	0.0476	0.170	-
4	0.0244	0.002	SELECT count(*) FROM xcart_sessions_data WHERE sessid='edc4f4c374e3a562e8891e14e00d2afc'
5	0.0002	0.000	-
6	0.0008	0.002	DELETE FROM xcart_sessions_data WHERE expiry<'1123768101'
81	0.0013	0.015	-
82	0.0288	0.003	SELECT xcart_products.productid, xcart_products.product, xcart_products.productcode, xcart_products.avail, MIN(xcart_pricing.price) AS price, xcart_product_features.fclassid, IF(xcart_product_features.fclassid IS NULL...
83	0.0003	-0.026	-
84	0.0719	0.001	SELECT name, value FROM xcart_languages WHERE code = 'US' AND name IN ('lbl_sku','lbl_product','lbl_price','lbl_default')
85	0.4190	0.271	-

SQL time: 2.4501 (76.62%)
PHP time: 0.2571 (8.04%)
Smarty time: 0.4910 (15.35%)
Used memory: 6.415Mb