bench_delete_truncate.php

Go to the documentation of this file.

<?php
require_once( __DIR__ . '/Benchmarker.php' );

class BenchmarkDeleteTruncate extends Benchmarker {

        public function __construct() {
                parent::__construct();
                $this->mDescription = "Benchmarks SQL DELETE vs SQL TRUNCATE.";
        }

        public function execute() {
                $dbw = wfGetDB( DB_MASTER );

                $test = $dbw->tableName( 'test' );
                $dbw->query( "CREATE TABLE IF NOT EXISTS /*_*/$test (
  test_id int unsigned NOT NULL PRIMARY KEY AUTO_INCREMENT,
  text varbinary(255) NOT NULL
);" );

                $this->insertData( $dbw );

                $start = microtime( true );

                $this->delete( $dbw );

                $end = microtime( true );

                echo "Delete: " . sprintf( "%6.3fms", ( $end - $start ) * 1000 );
                echo "\r\n";

                $this->insertData( $dbw );

                $start = microtime( true );

                $this->truncate( $dbw );

                $end = microtime( true );

                echo "Truncate: " . sprintf( "%6.3fms", ( $end - $start ) * 1000 );
                echo "\r\n";

                $dbw->dropTable( 'test' );
        }

        private function insertData( $dbw ) {
                $range = range( 0, 1024 );
                $data = array();
                foreach( $range as $r ) {
                        $data[] = array( 'text' => $r );
                }
                $dbw->insert( 'test', $data, __METHOD__ );
        }

        private function delete( $dbw ) {
                $dbw->delete( 'text', '*', __METHOD__ );
        }

        private function truncate( $dbw ) {
                $test = $dbw->tableName( 'test' );
                $dbw->query( "TRUNCATE TABLE $test" );
        }
}

$maintClass = "BenchmarkDeleteTruncate";
require_once( RUN_MAINTENANCE_IF_MAIN );