Changeset 5496

Timestamp:

05/17/2017 07:23:19 PM (9 years ago)

Author:

iandunn

Message:

Events: Track query execution time to aid optimization

The test suite isn't representative of real-world usage, because by nature it's weighted heavily towards edge cases. Establishing a performance baseline is still useful when optimizing, though.

See #2823

Props dd32

File:

• sites/trunk/api.wordpress.org/public_html/events/1.0/tests/test-index.php (modified) (1 diff)

sites/trunk/api.wordpress.org/public_html/events/1.0/tests/test-index.php

@@ -11 +11 @@
  */
 function run_tests() {
+        global $wpdb;
         define( 'RUNNING_TESTS', true );
+        define( 'SAVEQUERIES',   true );
+
         require_once( dirname( __DIR__ ) . '/index.php' );
 
-        $failed = 0;
-        $failed += test_get_location();
-        $failed += test_get_city_from_coordinates();
-
-        printf( "\n\nFinished running all tests. %d failed.\n", $failed );
+        $tests_failed = 0;
+        $tests_failed += test_get_location();
+        $tests_failed += test_get_city_from_coordinates();
+        $query_count  = count( $wpdb->queries );
+        $query_time   = array_sum( array_column( $wpdb->queries, 1 ) );
+
+        printf(
+                "\n\nFinished running all tests.\n\n* %d tests failed\n* %d queries ran in %f seconds\n* Average time per query: %f seconds\n",
+                $tests_failed,
+                $query_count,
+                $query_time,
+                $query_time / $query_count
+        );
 }