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;