sZL6pQpN

1<?php
2// Connect to MySQL and use DB
3$link = mysql_connect( 'tig.mysql.master', 'ezp', 'publish' ) or die( 'Could not connect: ' . mysql_error() );
4mysql_select_db( 'gha_4_3_0' ) or die( 'Could not select database' );
5
6$query  = 'DROP TABLE if exists perfomance_test';
7$result = mysql_query( $query ) or die( 'Query failed: ' . mysql_error() );
8
9$t = microtime( true );
10
11// Create schema
12$query = '
13CREATE TABLE perfomance_test(
14	`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
15	`tst_txt` text,
16	PRIMARY KEY(`id`)
17)
18ENGINE=InnoDB DEFAULT CHARSET=utf8';
19$result = mysql_query( $query ) or die( 'Query failed: ' . mysql_error() );
20
21// Insert data
22for( $i = 0; $i < 100; $i++ ) {
23	$query  = 'INSERT INTO perfomance_test (tst_txt) VALUES ( \'test line' . $i . '\' );';
24	$result = mysql_query( $query ) or die( 'Query failed: ' . mysql_error() );
25}
26
27// Read data
28for( $j = 0; $j < 30000; $j++ ) {
29	$query  = 'SELECT * FROM perfomance_test WHERE id > ' . rand( 0, 100 ) . ' LIMIT 10;';
30	$result = mysql_query( $query ) or die( 'Query failed: ' . mysql_error() );
31}
32
33// remove shema
34mysql_free_result( $result );
35$query  = 'DROP TABLE if exists perfomance_test';
36$result = mysql_query( $query ) or die( 'Query failed: ' . mysql_error() );
37mysql_close( $link );
38
39// output results
40echo 'Execution time: ' . number_format( microtime( true ) - $t , 2 ) . "\n";
41?>