bench_delete_truncate.php

Go to the documentation of this file.

<?php
require_once __DIR__ . '/Benchmarker.php';
 
use Wikimedia\Rdbms\IDatabase;
use Wikimedia\Rdbms\IMaintainableDatabase;
 
class BenchmarkDeleteTruncate extends Benchmarker {
    protected $defaultCount = 10;
 
    public function __construct() {
        parent::__construct();
        $this->addDescription( 'Benchmarks SQL DELETE vs SQL TRUNCATE.' );
    }
 
    public function execute() {
        $dbw = $this->getDB( 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->bench( [
            'Delete' => [
                'setup' => function () use ( $dbw ) {
                    $this->insertData( $dbw );
                },
                'function' => function () use ( $dbw ) {
                    $this->delete( $dbw );
                }
            ],
            'Truncate' => [
                'setup' => function () use ( $dbw ) {
                    $this->insertData( $dbw );
                },
                'function' => function () use ( $dbw ) {
                    $this->truncate( $dbw );
                }
            ]
        ] );
 
        $dbw->dropTable( 'test' );
    }
 
    private function insertData( $dbw ) {
        $range = range( 0, 1024 );
        $data = [];
        foreach ( $range as $r ) {
            $data[] = [ '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::class;
require_once RUN_MAINTENANCE_IF_MAIN;