X-Git-Url: https://git.heureux-cyclage.org/?a=blobdiff_plain;f=maintenance%2Fbenchmarks%2Fbench_delete_truncate.php;h=8ae4f0309428b44f4a61a28f04f2d0a017df73f3;hb=937ae6444a683a3b0aaf14c21f529ad0e91419ef;hp=6e448647cda244432fe11a58a2e9048e188f5c27;hpb=ddfce8feb06afe46bfa778be27c5b5b369861f5e;p=lhc%2Fweb%2Fwiklou.git diff --git a/maintenance/benchmarks/bench_delete_truncate.php b/maintenance/benchmarks/bench_delete_truncate.php index 6e448647cd..8ae4f03094 100644 --- a/maintenance/benchmarks/bench_delete_truncate.php +++ b/maintenance/benchmarks/bench_delete_truncate.php @@ -1,13 +1,34 @@ mDescription = "Benchmarks SQL DELETE vs SQL TRUNCATE."; @@ -24,44 +45,44 @@ class BenchmarkDeleteTruncate extends Benchmarker { $this->insertData( $dbw ); - $start = wfTime(); + $start = microtime( true ); $this->delete( $dbw ); - $end = wfTime(); + $end = microtime( true ); - echo "Delete: " . $end - $start; + echo "Delete: " . sprintf( "%6.3fms", ( $end - $start ) * 1000 ); echo "\r\n"; $this->insertData( $dbw ); - $start = wfTime(); + $start = microtime( true ); $this->truncate( $dbw ); - $end = wfTime(); + $end = microtime( true ); - echo "Truncate: " . $end - $start; + echo "Truncate: " . sprintf( "%6.3fms", ( $end - $start ) * 1000 ); echo "\r\n"; $dbw->dropTable( 'test' ); } /** - * @param $dbw DatabaseBase + * @param DatabaseBase $dbw * @return void */ private function insertData( $dbw ) { $range = range( 0, 1024 ); $data = array(); - foreach( $range as $r ) { + foreach ( $range as $r ) { $data[] = array( 'text' => $r ); } $dbw->insert( 'test', $data, __METHOD__ ); } /** - * @param $dbw DatabaseBase + * @param DatabaseBase $dbw * @return void */ private function delete( $dbw ) { @@ -69,7 +90,7 @@ class BenchmarkDeleteTruncate extends Benchmarker { } /** - * @param $dbw DatabaseBase + * @param DatabaseBase $dbw * @return void */ private function truncate( $dbw ) { @@ -79,4 +100,4 @@ class BenchmarkDeleteTruncate extends Benchmarker { } $maintClass = "BenchmarkDeleteTruncate"; -require_once( RUN_MAINTENANCE_IF_MAIN ); +require_once RUN_MAINTENANCE_IF_MAIN;