| List: | Commits | « Previous MessageNext Message » | |
| From: | uwendel | Date: | March 20 2007 4:09pm |
| Subject: | PHP mysqlnd svn commit: r211 - trunk/ext/mysqli/tests/bench/micro_benches | ||
| View as plain text | |||
Author: uwendel Date: 2007-03-20 16:09:00 +0100 (Tue, 20 Mar 2007) New Revision: 211 Added: trunk/ext/mysqli/tests/bench/micro_benches/andrey_stmt1.php trunk/ext/mysqli/tests/bench/micro_benches/andrey_stmt2.php trunk/ext/mysqli/tests/bench/micro_benches/mysqli_stmt_data_seek_random.php trunk/ext/mysqli/tests/bench/micro_benches/mysqli_stmt_data_seek_sequential.php trunk/ext/mysqli/tests/bench/micro_benches/mysqli_stmt_execute.php trunk/ext/mysqli/tests/bench/micro_benches/mysqli_stmt_execute_insert_varchar.php trunk/ext/mysqli/tests/bench/micro_benches/mysqli_stmt_execute_select_varchar_buffered.php trunk/ext/mysqli/tests/bench/micro_benches/mysqli_stmt_execute_select_varchar_unbuffered.php trunk/ext/mysqli/tests/bench/micro_benches/mysqli_stmt_fetch_many_columns_unbuffered.php Log: Ported a few non prepared-statement benchmarks to prepared-statements. My initial impression is that mysqlnd prepared statement are not that slow as we might fear. Added: trunk/ext/mysqli/tests/bench/micro_benches/andrey_stmt1.php =================================================================== --- trunk/ext/mysqli/tests/bench/micro_benches/andrey_stmt1.php 2007-03-20 15:05:27 UTC (rev 210) +++ trunk/ext/mysqli/tests/bench/micro_benches/andrey_stmt1.php 2007-03-20 15:09:00 UTC (rev 211) @@ -0,0 +1,98 @@ +<?PHP +/* Config settings should go at the very beginning */ +$rows = array(100, 1000, 10000, 100000); + +// Set a description +$description = 'This is a skeleton for a benchmark that does nothing.'; + + +/* + This is a hash that stores the runtimes + It is dumped in all reports. The hash keys will be used as labels/descriptions. + $times['select()'] = 0.01; => shown in reports like 'select() : 0.01s' +*/ +$times = array(); +/* + It's recommended to initialize the times hash with 0 values + for all entries. This often makes debugging easier. + Make sure you have one 'overall' entry in your list which + holds the 'entire runtime' of you test (e.g. create table + insert + select) and not only + a fraction of it (e.g. select). +*/ +foreach ($rows as $k => $num_rows) { + $times[sprintf("%7d: overall", $num_rows)] = 0; + $times[sprintf("%7d: query", $num_rows)] = 0; + $times[sprintf("%7d: fetch()", $num_rows)] = 0; +} + +/* + List of errors that happened during the test run. You should stop + the benchmark after the first error +*/ +$errors = array(); + + +do { + + if (!$link = mysqli_connect($host, $user, $passwd, $db, $port, $socket)) { + $errors[] = sprintf("Connect failure (converted code: %s)\n", ($flag_original_code) ? 'no' : 'yes'); + break; + } + + if (!mysqli_query($link, "DROP TABLE IF EXISTS test")) { + $errors[] = sprintf("DROP TABLE IF EXISTS failure (converted code: %s)\n", ($flag_original_code) ? 'no' : 'yes'); + break; + } + + if (!mysqli_query($link, "CREATE TABLE test(a INT, b CHAR(1), c CHAR(1), d CHAR(1))")) { + $errors[] = sprintf("CREATE TABLE failure (converted code: %s)\n", ($flag_original_code) ? 'no' : 'yes'); + break; + } + + foreach ($rows as $k => $num_rows) { + + if (!mysqli_query($link, "TRUNCATE TABLE test")) { + $errors[] = sprintf("TRUNCATE failure (converted code: %s)\n", ($flag_original_code) ? 'no' : 'yes'); + break 2; + } + for ($i = 0; $i < $num_rows; $i++) { + if (!mysqli_query($link, sprintf("INSERT INTO test(a, b, c, d) VALUES (%d, 'a', 'b', 'c')", $i))) { + $errors[] = sprintf("TRUNCATE failure (converted code: %s)\n", ($flag_original_code) ? 'no' : 'yes'); + break 3; + } + } + + $times[sprintf("%7d: overall", $num_rows)] = $start = microtime(true); + + if (!$stmt = mysqli_stmt_init($link)) { + $errors[] = sprintf("stmt_init() failure (converted code: %s)\n", ($flag_original_code) ? 'no' : 'yes'); + break 2; + } + if (!mysqli_stmt_prepare($stmt, 'SELECT * FROM test')) { + $errors[] = sprintf("stmt_prepare() failure (converted code: %s)\n", ($flag_original_code) ? 'no' : 'yes'); + break 2; + } + if (!mysqli_stmt_execute($stmt)) { + $errors[] = sprintf("stmt_execute() failure (converted code: %s)\n", ($flag_original_code) ? 'no' : 'yes'); + break 2; + } + + $row = array(0 => null, 1 => null, 2 => null, 3 => null); + if (!mysqli_stmt_bind_result($stmt, $row[0], $row[1], $row[2], $row[3])) { + $errors[] = sprintf("stmt_execute() failure (converted code: %s)\n", ($flag_original_code) ? 'no' : 'yes'); + break 2; + } + $times[sprintf("%7d: query", $num_rows)] = (microtime(true) - $start); + + $start = microtime(true); + while (mysqli_stmt_fetch($stmt)) + ; + $times[sprintf("%7d: stmt_fetch()", $num_rows)] = (microtime(true) - $start); + + $times[sprintf("%7d: overall", $num_rows)] = (microtime(true) - $times[sprintf("%7d: overall", $num_rows)]); + } + + mysqli_close($link); + +} while (false); +?> \ No newline at end of file Added: trunk/ext/mysqli/tests/bench/micro_benches/andrey_stmt2.php =================================================================== --- trunk/ext/mysqli/tests/bench/micro_benches/andrey_stmt2.php 2007-03-20 15:05:27 UTC (rev 210) +++ trunk/ext/mysqli/tests/bench/micro_benches/andrey_stmt2.php 2007-03-20 15:09:00 UTC (rev 211) @@ -0,0 +1,100 @@ +<?PHP +/* Config settings should go at the very beginning */ +$rows = array(100, 1000, 10000, 100000); + +// Set a description +$description = 'This is a skeleton for a benchmark that does nothing.'; + + +/* + This is a hash that stores the runtimes + It is dumped in all reports. The hash keys will be used as labels/descriptions. + $times['select()'] = 0.01; => shown in reports like 'select() : 0.01s' +*/ +$times = array(); +/* + It's recommended to initialize the times hash with 0 values + for all entries. This often makes debugging easier. + Make sure you have one 'overall' entry in your list which + holds the 'entire runtime' of you test (e.g. create table + insert + select) and not only + a fraction of it (e.g. select). +*/ +foreach ($rows as $k => $num_rows) { + $times[sprintf("%7d: overall", $num_rows)] = 0; + $times[sprintf("%7d: query", $num_rows)] = 0; + $times[sprintf("%7d: fetch()", $num_rows)] = 0; +} + +/* + List of errors that happened during the test run. You should stop + the benchmark after the first error +*/ +$errors = array(); + + +do { + + if (!$link = mysqli_connect($host, $user, $passwd, $db, $port, $socket)) { + $errors[] = sprintf("Connect failure (converted code: %s)\n", ($flag_original_code) ? 'no' : 'yes'); + break; + } + + if (!mysqli_query($link, "DROP TABLE IF EXISTS test")) { + $errors[] = sprintf("DROP TABLE IF EXISTS failure (converted code: %s)\n", ($flag_original_code) ? 'no' : 'yes'); + break; + } + + if (!mysqli_query($link, "CREATE TABLE test(a INT, b CHAR(255), c CHAR(255), d CHAR(255))")) { + $errors[] = sprintf("CREATE TABLE failure (converted code: %s)\n", ($flag_original_code) ? 'no' : 'yes'); + break; + } + + foreach ($rows as $k => $num_rows) { + + if (!mysqli_query($link, "TRUNCATE TABLE test")) { + $errors[] = sprintf("TRUNCATE failure (converted code: %s)\n", ($flag_original_code) ? 'no' : 'yes'); + break 2; + } + $label = str_repeat('a', 255); + for ($i = 0; $i < $num_rows; $i++) { + if (!mysqli_query($link, sprintf("INSERT INTO test(a, b, c, d) VALUES (%d, '%s', '%s', '%s')", + $i, $label, $label, $label))) { + $errors[] = sprintf("TRUNCATE failure (converted code: %s)\n", ($flag_original_code) ? 'no' : 'yes'); + break 3; + } + } + + $times[sprintf("%7d: overall", $num_rows)] = $start = microtime(true); + + if (!$stmt = mysqli_stmt_init($link)) { + $errors[] = sprintf("stmt_init() failure (converted code: %s)\n", ($flag_original_code) ? 'no' : 'yes'); + break 2; + } + if (!mysqli_stmt_prepare($stmt, 'SELECT * FROM test')) { + $errors[] = sprintf("stmt_prepare() failure (converted code: %s)\n", ($flag_original_code) ? 'no' : 'yes'); + break 2; + } + if (!mysqli_stmt_execute($stmt)) { + $errors[] = sprintf("stmt_execute() failure (converted code: %s)\n", ($flag_original_code) ? 'no' : 'yes'); + break 2; + } + + $row = array(0 => null, 1 => null, 2 => null, 3 => null); + if (!mysqli_stmt_bind_result($stmt, $row[0], $row[1], $row[2], $row[3])) { + $errors[] = sprintf("stmt_execute() failure (converted code: %s)\n", ($flag_original_code) ? 'no' : 'yes'); + break 2; + } + $times[sprintf("%7d: query", $num_rows)] = (microtime(true) - $start); + + $start = microtime(true); + while (mysqli_stmt_fetch($stmt)) + ; + $times[sprintf("%7d: stmt_fetch()", $num_rows)] = (microtime(true) - $start); + + $times[sprintf("%7d: overall", $num_rows)] = (microtime(true) - $times[sprintf("%7d: overall", $num_rows)]); + } + + mysqli_close($link); + +} while (false); +?> \ No newline at end of file Added: trunk/ext/mysqli/tests/bench/micro_benches/mysqli_stmt_data_seek_random.php =================================================================== --- trunk/ext/mysqli/tests/bench/micro_benches/mysqli_stmt_data_seek_random.php 2007-03-20 15:05:27 UTC (rev 210) +++ trunk/ext/mysqli/tests/bench/micro_benches/mysqli_stmt_data_seek_random.php 2007-03-20 15:09:00 UTC (rev 211) @@ -0,0 +1,148 @@ +<?PHP +$runs = array(10, 100); +$rows = array(100, 1000); +$types = array( + 16 => 'varchar(16)', + 32 => 'varchar(32)', + 64 => 'varchar(64)', + 128 => 'varchar(128)', + 256 => 'varchar(256)', + 512 => 'varchar(512)', + 1024 => 'varchar(1024)', + 2048 => 'varchar(2048)', + 4192 => 'varchar(4192)', + 8384 => 'varchar(8384)', + 16768 => 'varchar(16768)', + 33536 => 'varchar(33536)', + 65500 => 'varchar(65500)' + + ); +foreach ($runs as $k => $num_runs) { + foreach ($rows as $k => $num_rows) { + foreach ($types as $len => $type) { + $times[$num_rows . ' rows: ' . $num_runs . 'x ' . $type . ' overall'] = 0; + $times[$num_rows . ' rows: ' . $num_runs . 'x ' . $type . ' data_seek()'] = 0; + } + } +} +$description = 'Connect, create n-rows with varchar(m), SELECT all, o-times [$runs] mysqli_stmt_data_seek(mt_rand()), close. n, m and o vary.'; +$errors = array(); + +do { + + if (!$link = mysqli_connect($host, $user, $passwd, $db, $port, $socket)) { + $errors[] = sprintf("Connect failure (converted code: %s)\n", ($flag_original_code) ? 'no' : 'yes'); + break; + } + + foreach ($types as $len => $type) { + + if (!mysqli_query($link, "DROP TABLE IF EXISTS test")) { + $errors[] = sprintf("DROP TABLE failed (converted code: %s): [%d] %s\n", + ($flag_original_code) ? 'no' : 'yes', + mysqli_errno($link), mysqli_error($link)); + break 2; + } + + $sql = sprintf("CREATE TABLE test(id INT, label %s)", $type); + if (!mysqli_query($link, $sql)) { + $errors[] = sprintf("CREATE TABLE (%s) failed (converted code: %s): [%d] %s\n", + $sql, + ($flag_original_code) ? 'no' : 'yes', + mysqli_errno($link), mysqli_error($link)); + break 2; + } + + foreach ($rows as $k => $num_rows) { + foreach ($runs as $k => $num_runs) { + + // create n-rows + if (!mysqli_query($link, "DELETE FROM test")) { + $errors[] = sprintf("DELETE failed (%s) (converted code: %s): [%d] %s\n", + $type, + ($flag_original_code) ? 'no' : 'yes', + mysqli_errno($link), mysqli_error($link)); + break 4; + } + + $label = str_repeat('a', $len); + for ($i = 0; $i < $num_rows; $i++) { + $sql = sprintf("INSERT INTO test(id, label) VALUES (%d, '%s')", $i, $label); + if (!mysqli_query($link, $sql)) { + $errors[] = sprintf("INSERT failed (%s) (converted code: %s): [%d] %s\n", + $type, + ($flag_original_code) ? 'no' : 'yes', + mysqli_errno($link), mysqli_error($link)); + break 5; + } + } + + if (!$stmt = mysqli_stmt_init($link)) { + $errors[] = sprintf("stmt_init() failed (converted code: %s)\n", + ($flag_original_code) ? 'no' : 'yes'); + break 4; + } + if (!mysqli_stmt_prepare($stmt, 'SELECT id, label FROM test ORDER BY id')) { + $errors[] = sprintf("stmt_prepare() failed (converted code: %s)\n", + ($flag_original_code) ? 'no' : 'yes'); + break 4; + } + if (!mysqli_stmt_execute($stmt)) { + $errors[] = sprintf("stmt_execute() failed (converted code: %s)\n", + ($flag_original_code) ? 'no' : 'yes'); + break 4; + } + $id = $label = null; + if (!mysqli_stmt_bind_result($stmt, $id, $label)) { + $errors[] = sprintf("stmt_bind_result() failed (converted code: %s)\n", + ($flag_original_code) ? 'no' : 'yes'); + break 4; + } + if (!mysqli_stmt_store_result($stmt)) { + $errors[] = sprintf("stmt_store_result() failed (converted code: %s)\n", + ($flag_original_code) ? 'no' : 'yes'); + break 4; + } + + mt_srand(); + $times[$num_rows . ' rows: ' . $num_runs . 'x ' . $type . ' overall'] = microtime(true); + for ($i = 0; $i < $num_runs; $i++) { + + $pos = mt_rand(0, $num_rows - 1); + + $start = microtime(true); + mysqli_stmt_data_seek($stmt, $pos); + $times[$num_rows . ' rows: ' . $num_runs . 'x ' . $type . ' data_seek()'] += (microtime(true) - $start); + + if (!mysqli_stmt_fetch($stmt)) { + $errors[] = sprintf("fetch() for %dth of %d rows failed (%s) (converted code: %s): [%d] %s\n", + $pos, $num_rows, $type, + ($flag_original_code) ? 'no' : 'yes', + mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); + break 5; + } + + if ($id != $pos) { + $errors[] = sprintf("seek() + fetch() for %dth of %d rows did not work (%s) (converted code: %s): [%d] %s\n", + $pos, $num_rows, $type, + ($flag_original_code) ? 'no' : 'yes', + mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); + var_dump($id); + var_dump($pos); + break 5; + } + + } + $times[$num_rows . ' rows: ' . $num_runs . 'x ' . $type . ' overall'] = microtime(true) - $times[$num_rows . ' rows: ' . $num_runs . 'x ' . $type . ' overall']; + + mysqli_stmt_close($stmt); + } + } + + } // end foreach types + + + mysqli_close($link); + +} while (false); +?> \ No newline at end of file Added: trunk/ext/mysqli/tests/bench/micro_benches/mysqli_stmt_data_seek_sequential.php =================================================================== --- trunk/ext/mysqli/tests/bench/micro_benches/mysqli_stmt_data_seek_sequential.php 2007-03-20 15:05:27 UTC (rev 210) +++ trunk/ext/mysqli/tests/bench/micro_benches/mysqli_stmt_data_seek_sequential.php 2007-03-20 15:09:00 UTC (rev 211) @@ -0,0 +1,147 @@ +<?PHP +$runs = array(10, 100); +$rows = array(100, 1000); +$types = array( + 16 => 'varchar(16)', + 32 => 'varchar(32)', + 64 => 'varchar(64)', + 128 => 'varchar(128)', + 256 => 'varchar(256)', + 512 => 'varchar(512)', + 1024 => 'varchar(1024)', + 2048 => 'varchar(2048)', + 4192 => 'varchar(4192)', + 8384 => 'varchar(8384)', + 16768 => 'varchar(16768)', + 33536 => 'varchar(33536)', + 65500 => 'varchar(65500)' + + ); +foreach ($runs as $k => $num_runs) { + foreach ($rows as $k => $num_rows) { + foreach ($types as $len => $type) { + $times[$num_rows . ' rows: ' . $num_runs . 'x ' . $type . ' overall'] = 0; + $times[$num_rows . ' rows: ' . $num_runs . 'x ' . $type . ' data_seek()'] = 0; + } + } +} +$description = 'Connect, create n-rows with varchar(m), SELECT all, fetch them in reverse order using o-times [$runs] mysqli_stmt_data_seek(n...0), close. n, m and o vary.'; +$errors = array();$errors = array(); + +do { + + if (!$link = mysqli_connect($host, $user, $passwd, $db, $port, $socket)) { + $errors[] = sprintf("Connect failure (converted code: %s)\n", ($flag_original_code) ? 'no' : 'yes'); + break; + } + + foreach ($types as $len => $type) { + + if (!mysqli_query($link, "DROP TABLE IF EXISTS test")) { + $errors[] = sprintf("DROP TABLE failed (converted code: %s): [%d] %s\n", + ($flag_original_code) ? 'no' : 'yes', + mysqli_errno($link), mysqli_error($link)); + break 2; + } + + $sql = sprintf("CREATE TABLE test(id INT, label %s)", $type); + if (!mysqli_query($link, $sql)) { + $errors[] = sprintf("CREATE TABLE (%s) failed (converted code: %s): [%d] %s\n", + $sql, + ($flag_original_code) ? 'no' : 'yes', + mysqli_errno($link), mysqli_error($link)); + break 2; + } + + foreach ($rows as $k => $num_rows) { + foreach ($runs as $k => $num_runs) { + + // create n-rows + if (!mysqli_query($link, "DELETE FROM test")) { + $errors[] = sprintf("DELETE failed (%s) (converted code: %s): [%d] %s\n", + $type, + ($flag_original_code) ? 'no' : 'yes', + mysqli_errno($link), mysqli_error($link)); + break 4; + } + + $label = str_repeat('a', $len); + for ($i = 0; $i < $num_rows; $i++) { + $sql = sprintf("INSERT INTO test(id, label) VALUES (%d, '%s')", $i, $label); + if (!mysqli_query($link, $sql)) { + $errors[] = sprintf("INSERT failed (%s) (converted code: %s): [%d] %s\n", + $type, + ($flag_original_code) ? 'no' : 'yes', + mysqli_errno($link), mysqli_error($link)); + break 5; + } + } + + if (!$stmt = mysqli_stmt_init($link)) { + $errors[] = sprintf("stmt_init() failed (converted code: %s)\n", + ($flag_original_code) ? 'no' : 'yes'); + break 4; + } + if (!mysqli_stmt_prepare($stmt, 'SELECT id, label FROM test ORDER BY id')) { + $errors[] = sprintf("stmt_prepare() failed (converted code: %s)\n", + ($flag_original_code) ? 'no' : 'yes'); + break 4; + } + if (!mysqli_stmt_execute($stmt)) { + $errors[] = sprintf("stmt_execute() failed (converted code: %s)\n", + ($flag_original_code) ? 'no' : 'yes'); + break 4; + } + $id = $label = null; + if (!mysqli_stmt_bind_result($stmt, $id, $label)) { + $errors[] = sprintf("stmt_bind_result() failed (converted code: %s)\n", + ($flag_original_code) ? 'no' : 'yes'); + break 4; + } + if (!mysqli_stmt_store_result($stmt)) { + $errors[] = sprintf("stmt_store_result() failed (converted code: %s)\n", + ($flag_original_code) ? 'no' : 'yes'); + break 4; + } + + $times[$num_rows . ' rows: ' . $num_runs . 'x ' . $type . ' overall'] = microtime(true); + for ($i = 0; $i < $num_runs; $i++) { + + $pos = $num_runs - $i - 1; + + $start = microtime(true); + mysqli_stmt_data_seek($stmt, $pos); + $times[$num_rows . ' rows: ' . $num_runs . 'x ' . $type . ' data_seek()'] += (microtime(true) - $start); + + if (!mysqli_stmt_fetch($stmt)) { + $errors[] = sprintf("fetch() for %dth of %d rows failed (%s) (converted code: %s): [%d] %s\n", + $pos, $num_rows, $type, + ($flag_original_code) ? 'no' : 'yes', + mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); + break 5; + } + + if ($id != $pos) { + $errors[] = sprintf("seek() + fetch() for %dth of %d rows did not work (%s) (converted code: %s): [%d] %s\n", + $pos, $num_rows, $type, + ($flag_original_code) ? 'no' : 'yes', + mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); + var_dump($id); + var_dump($pos); + break 5; + } + + } + $times[$num_rows . ' rows: ' . $num_runs . 'x ' . $type . ' overall'] = microtime(true) - $times[$num_rows . ' rows: ' . $num_runs . 'x ' . $type . ' overall']; + + mysqli_stmt_close($stmt); + } + } + + } // end foreach types + + + mysqli_close($link); + +} while (false); +?> \ No newline at end of file Added: trunk/ext/mysqli/tests/bench/micro_benches/mysqli_stmt_execute.php =================================================================== --- trunk/ext/mysqli/tests/bench/micro_benches/mysqli_stmt_execute.php 2007-03-20 15:05:27 UTC (rev 210) +++ trunk/ext/mysqli/tests/bench/micro_benches/mysqli_stmt_execute.php 2007-03-20 15:09:00 UTC (rev 211) @@ -0,0 +1,71 @@ +<?PHP +/* Config settings should go at the very beginning */ +$runs = 10000; + +// Set a description +$description = 'Call stmt_execute() for "SELECT 1"'; + + +/* + This is a hash that stores the runtimes + It is dumped in all reports. The hash keys will be used as labels/descriptions. + $times['select()'] = 0.01; => shown in reports like 'select() : 0.01s' +*/ +$times = array(); +/* + It's recommended to initialize the times hash with 0 values + for all entries. This often makes debugging easier. + Make sure you have one 'overall' entry in your list which + holds the 'entire runtime' of you test (e.g. create table + insert + select) and not only + a fraction of it (e.g. select). +*/ +$times['overall'] = 0; +$times['execute'] = 0; + +/* + List of errors that happened during the test run. You should stop + the benchmark after the first error +*/ +$errors = array(); + + +do { + + $times['overall'] = microtime(true); + + /* + Use this to connect to the database. The variables $host, ... + $socket and $flag_original_code are provided by the framework + */ + if (!$link = mysqli_connect($host, $user, $passwd, $db, $port, $socket)) { + $errors[] = sprintf("Connect failure (converted code: %s)\n", ($flag_original_code) ? 'no' : 'yes'); + break; + } + + if (!$stmt = mysqli_stmt_init($link)) { + $errors[] = sprintf("stmt_init() (converted code: %s)\n", ($flag_original_code) ? 'no' : 'yes'); + break; + } + + if (!mysqli_stmt_prepare($stmt, "SELECT 1")) { + $errors[] = sprintf("stmt_prepare() (converted code: %s)\n", ($flag_original_code) ? 'no' : 'yes'); + break; + } + + $start = microtime(true); + for ($i = 0; $i < $runs; $i++) { + if (!@mysqli_stmt_execute($stmt)) { + $errors[] = sprintf("stmt_execute() (converted code: %s)\n", ($flag_original_code) ? 'no' : 'yes'); + break 2; + } + mysqli_stmt_free_result($stmt); + } + $times['execute'] = microtime(true) - $start; + + + @mysqli_stmt_close($stmt); + mysqli_close($link); + $times['overall'] = (microtime(true) - $times['overall']); + +} while (false); +?> \ No newline at end of file Added: trunk/ext/mysqli/tests/bench/micro_benches/mysqli_stmt_execute_insert_varchar.php =================================================================== --- trunk/ext/mysqli/tests/bench/micro_benches/mysqli_stmt_execute_insert_varchar.php 2007-03-20 15:05:27 UTC (rev 210) +++ trunk/ext/mysqli/tests/bench/micro_benches/mysqli_stmt_execute_insert_varchar.php 2007-03-20 15:09:00 UTC (rev 211) @@ -0,0 +1,95 @@ +<?PHP +$runs = array(1, 10, 100, 1000, 5000); // equals #rows +$types = array( + 127 => 'varchar(127)', + 255 => 'varchar(255)', + 512 => 'varchar(512)', + 1024 => 'varchar(1024)', + 2048 => 'varchar(2048)', + 4096 => 'varchar(4096)', + 8192 => 'varchar(8192)', + 16384 => 'varchar(16384)', + 32768 => 'varchar(32768)', + ); +foreach ($runs as $k => $run) { + foreach ($types as $len => $type) { + $times['INSERT ' . $type . ' ' . $run . 'x = #rows query()'] = 0; + $times['INSERT ' . $type . ' ' . $run . 'x = #rows overall'] = 0; + } +} +$description = 'Connect, n-times INSERT varchar of size m, close. n and m vary.'; +$errors = array(); + +function mysqli_query_insert($type, $len, $runs, $host, $user, $passwd, $db, $port, $socket) { + + $errors = $times = array(); + + foreach ($runs as $k => $run) { + $times['INSERT ' . $type . ' ' . $run . 'x = #rows overall'] = microtime(true); + do { + if (!$link = @mysqli_connect($host, $user, $passwd, $db, $port, $socket)) { + $errors[] = sprintf("INSERT %s %dx = #rows connect failure (original code = %s)", $type, $run, ($flag_original_code) ? 'yes' : 'no'); + break 2; + } + if (!mysqli_query($link, "DROP TABLE IF EXISTS test")) { + $errors[] = sprintf("INSERT %s %dx = #rows drop table failure (original code = %s): [%d] %s", $type, $run, ($flag_original_code) ? 'yes' : 'no', mysqli_errno($link), mysqli_error($link)); + break 2; + } + + if (!mysqli_query($link, sprintf("CREATE TABLE test(id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, label %s)", $type))) { + $errors[] = sprintf("INSERT %s %dx = #rows create table failure (original code = %s): [%d] %s", $type, $run, ($flag_original_code) ? 'yes' : 'no', mysqli_errno($link), mysqli_error($link)); + break 2; + } + + $label = ''; + for ($i = 0; $i < $len; $i++) + $label .= chr(mt_rand(65, 90)); + + $start = microtime(true); + if (!$stmt = mysqli_stmt_init($link)) { + $error[] = sprintf("INSERT %s %dx = #rows mysqli_stmt_init() failed (original code = %s): [%d] %s", $type, $run, ($flag_original_code) ? 'yes' : 'no', mysqli_errno($link), mysqli_error($link)); + break 2; + } + $ret = mysqli_stmt_prepare($stmt, "INSERT INTO test(id, label) VALUES (?, ?)"); + $times['INSERT ' . $type . ' ' . $run . 'x = #rows stmt_init() + stmt_prepare()'] += microtime(true) - $start; + if (!$ret) { + $error[] = sprintf("INSERT %s %dx = #rows mysqli_stmt_init() failed (original code = %s): [%d] %s", $type, $run, ($flag_original_code) ? 'yes' : 'no', mysqli_errno($link), mysqli_error($link)); + break 2; + } + + $start = microtime(true); + $ret = mysqli_stmt_bind_param($stmt, 'is', $i, $label); + $times['INSERT ' . $type . ' ' . $run . 'x = #rows stmt_bind_param()'] += microtime(true) - $start; + if (!$ret) { + $error[] = sprintf("INSERT %s %dx = #rows mysqli_stmt_bind_param failed (original code = %s): [%d] %s", $type, $run, ($flag_original_code) ? 'yes' : 'no', mysqli_errno($link), mysqli_error($link)); + break 2; + } + + for ($i = 1; $i <= $run; $i++) { + $start = microtime(true); + $ret = mysqli_stmt_execute($stmt); + $times['INSERT ' . $type . ' ' . $run . 'x = #rows stmt_execute()'] += microtime(true) - $start; + if (!$ret) { + $errors[] = sprintf("INSERT %s %dx = #rows stmt_execute failure (original code = %s): [%d] %s", $type, $run, ($flag_original_code) ? 'yes' : 'no', mysqli_errno($link), mysqli_error($link)); + break 3; + } + } + mysqli_stmt_close($stmt); + mysqli_close($link); + } while (false); + $times['INSERT ' . $type . ' ' . $run . 'x = #rows overall'] = microtime(true) - $times['INSERT ' . $type . ' ' . $run . 'x = #rows overall']; + } + + return array($errors, $times); +} + + +ksort($types); +foreach ($types as $len => $type) { + list ($errors, $tmp_times) = mysqli_query_insert($type, $len, $runs, $host, $user, $passwd, $db, $port, $socket); + $times = array_merge($times, $tmp_times); + if (!empty($errors)) { + break; + } +} +?> \ No newline at end of file Added: trunk/ext/mysqli/tests/bench/micro_benches/mysqli_stmt_execute_select_varchar_buffered.php =================================================================== --- trunk/ext/mysqli/tests/bench/micro_benches/mysqli_stmt_execute_select_varchar_buffered.php 2007-03-20 15:05:27 UTC (rev 210) +++ trunk/ext/mysqli/tests/bench/micro_benches/mysqli_stmt_execute_select_varchar_buffered.php 2007-03-20 15:09:00 UTC (rev 211) @@ -0,0 +1,155 @@ +<?PHP +$runs = array(10, 100); +$rows = array(100, 1000); +$types = array( + 127 => 'varchar(127)', + 255 => 'varchar(255)', + 512 => 'varchar(512)', + 1024 => 'varchar(1024)', + 2048 => 'varchar(2048)', + 4096 => 'varchar(4096)', + 8192 => 'varchar(8192)', + 16384 => 'varchar(16384)', + 32768 => 'varchar(32768)', + 65000 => 'varchar(65000)', + ); +$times = array(); +foreach ($rows as $k => $num_rows) { + foreach ($runs as $k => $run) { + foreach ($types as $len => $type) { + $times[$num_rows . ' rows: SELECT ' . $type . ' ' . $run . 'x query()'] = 0; + $times[$num_rows . ' rows: SELECT ' . $type . ' ' . $run . 'x overall'] = 0; + $times[$num_rows . ' rows: SELECT ' . $type . ' ' . $run . 'x fetch_assoc()'] = 0; + } + } +} +$description = 'Connect, create n rows with varchar of size m, o-times SELECT all rows (unbuffered), close. n, m, o vary.'; +$errors = array(); + +function mysqli_query_select_varchar_unbuffered($type, $len, $runs, $rows, $host, $user, $passwd, $db, $port, $socket, $flag_original_code) { + + $errors = $times = array(); + + foreach ($rows as $k => $num_rows) { + + foreach ($runs as $k => $run) { + + $times[$num_rows . ' rows: SELECT ' . $type . ' ' . $run . 'x overall'] = microtime(true); + + do { + if (!$link = @mysqli_connect($host, $user, $passwd, $db, $port, $socket)) { + $errors[] = sprintf("%d rows: SELECT %s %dx connect failure (original code = %s)", + $num_rows, $type, $run, ($flag_original_code) ? 'yes' : 'no'); + break 3; + } + if (!mysqli_query($link, "DROP TABLE IF EXISTS test")) { + $errors[] = sprintf("%d rows: SELECT %s %dx drop table failure (original code = %s): [%d] %s", + $num_rows, $type, $run, ($flag_original_code) ? 'yes' : 'no', mysqli_errno($link), mysqli_error($link)); + break 3; + } + + if (!mysqli_query($link, sprintf("CREATE TABLE test(id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, label %s)", $type))) { + $errors[] = sprintf("%d rows: SELECT %s %dx create table failure (original code = %s): [%d] %s", + $num_rows, $type, $run, ($flag_original_code) ? 'yes' : 'no', mysqli_errno($link), mysqli_error($link)); + break 3; + } + + $label = ''; + for ($i = 0; $i < $len; $i++) + $label .= chr(mt_rand(65, 90)); + + if (!$stmt = mysqli_stmt_init($link)) { + $errors[] = sprintf("%d rows: SELECT %s %dx stmt_init() for INSERT failed (original code = %s): [%d] %s", + $num_rows, $type, $run, ($flag_original_code) ? 'yes' : 'no', mysqli_errno($link), mysqli_error($link)); + break 3; + } + if (!mysqli_stmt_prepare($stmt, "INSERT INTO test(id, label) VALUES (?, ?)")) { + $errors[] = sprintf("%d rows: SELECT %s %dx stmt_prepare() for INSERT failed (original code = %s): [%d] %s", + $num_rows, $type, $run, ($flag_original_code) ? 'yes' : 'no', mysqli_errno($link), mysqli_error($link)); + break 3; + } + if (!mysqli_stmt_bind_param($stmt, "is", $i, $label)) { + $errors[] = sprintf("%d rows: SELECT %s %dx stmt_bind_param() for INSERT failed (original code = %s): [%d] %s", + $num_rows, $type, $run, ($flag_original_code) ? 'yes' : 'no', mysqli_errno($link), mysqli_error($link)); + break 3; + } + + for ($i = 1; $i <= $num_rows; $i++) { + if (!mysqli_stmt_execute($stmt)) { + $errors[] = sprintf("%d rows: SELECT %s %dx insert failure (original code = %s): [%d] %s", + $num_rows, $type, $run, ($flag_original_code) ? 'yes' : 'no', mysqli_errno($link), mysqli_error($link)); + break 4; + } + } + mysqli_stmt_close($stmt); + + + for ($i = 0; $i < $run; $i++) { + + if (!$stmt = mysqli_stmt_init($link)) { + $errors[] = sprintf("%d rows: SELECT %s %dx stmt_init() for SELECT failed (original code = %s): [%d] %s", + $num_rows, $type, $run, ($flag_original_code) ? 'yes' : 'no', mysqli_errno($link), mysqli_error($link)); + break 4; + } + if (!mysqli_stmt_prepare($stmt, "SELECT id, label FROM test")) { + $errors[] = sprintf("%d rows: SELECT %s %dx stmt_prepare() for SELECT failed (original code = %s): [%d] %s", + $num_rows, $type, $run, ($flag_original_code) ? 'yes' : 'no', mysqli_errno($link), mysqli_error($link)); + break 4; + } + $start = microtime(true); + $ret = mysqli_stmt_execute($stmt); + $times[$num_rows . ' rows: SELECT ' . $type . ' ' . $run . 'x stmt_execute()'] += (microtime(true) - $start); + if (!$ret) { + $errors[] = sprintf("%d rows: SELECT %s %dx insert failure (original code = %s): [%d] %s", + $rows, $type, $run, ($flag_original_code) ? 'yes' : 'no', mysqli_errno($link), mysqli_error($link)); + break 4; + } + + $start = microtime(true); + $ret = mysqli_stmt_store_result($stmt); + $times[$num_rows . ' rows: SELECT ' . $type . ' ' . $run . 'x stmt_store_result()'] += (microtime(true) - $start); + if (!$ret) { + $errors[] = sprintf("%d rows: SELECT %s %dx insert failure (original code = %s): [%d] %s", + $rows, $type, $run, ($flag_original_code) ? 'yes' : 'no', mysqli_errno($link), mysqli_error($link)); + break 4; + } + + if (!mysqli_stmt_bind_result($stmt, $id2, $label2)) { + $errors[] = sprintf("%d rows: SELECT %s %dx stmt_prepare() for SELECT failed (original code = %s): [%d] %s", + $num_rows, $type, $run, ($flag_original_code) ? 'yes' : 'no', mysqli_errno($link), mysqli_error($link)); + break 4; + } + + $start = microtime(true); + while (mysqli_stmt_fetch($stmt)) + ; + $times[$num_rows . ' rows: SELECT ' . $type . ' ' . $run . 'x stmt_fetch()'] += (microtime(true) - $start); + mysqli_stmt_close($stmt); + + } + + mysqli_close($link); + + } while (false); + + $times[$num_rows . ' rows: SELECT ' . $type . ' ' . $run . 'x overall'] = microtime(true) - $times[$num_rows . ' rows: SELECT ' . $type . ' ' . $run . 'x overall']; + + } + + } + + return array($errors, $times); +} + + +foreach ($types as $len => $type) { + list ($errors, $tmp_times) = mysqli_query_select_varchar_unbuffered($type, $len, $runs, $rows, $host, $user, $passwd, $db, $port, $socket, $flag_original_code); + $times = array_merge($times, $tmp_times); + if (!empty($errors)) { + break; + } +} + +// sort by labels +ksort($times); +?> Added: trunk/ext/mysqli/tests/bench/micro_benches/mysqli_stmt_execute_select_varchar_unbuffered.php =================================================================== --- trunk/ext/mysqli/tests/bench/micro_benches/mysqli_stmt_execute_select_varchar_unbuffered.php 2007-03-20 15:05:27 UTC (rev 210) +++ trunk/ext/mysqli/tests/bench/micro_benches/mysqli_stmt_execute_select_varchar_unbuffered.php 2007-03-20 15:09:00 UTC (rev 211) @@ -0,0 +1,147 @@ +<?PHP +$runs = array(10, 100); +$rows = array(100, 1000); +$types = array( + 127 => 'varchar(127)', + 255 => 'varchar(255)', + 512 => 'varchar(512)', + 1024 => 'varchar(1024)', + 2048 => 'varchar(2048)', + 4096 => 'varchar(4096)', + 8192 => 'varchar(8192)', + 16384 => 'varchar(16384)', + 32768 => 'varchar(32768)', + 65000 => 'varchar(65000)', + ); +$times = array(); +foreach ($rows as $k => $num_rows) { + foreach ($runs as $k => $run) { + foreach ($types as $len => $type) { + $times[$num_rows . ' rows: SELECT ' . $type . ' ' . $run . 'x query()'] = 0; + $times[$num_rows . ' rows: SELECT ' . $type . ' ' . $run . 'x overall'] = 0; + $times[$num_rows . ' rows: SELECT ' . $type . ' ' . $run . 'x fetch_assoc()'] = 0; + } + } +} +$description = 'Connect, create n rows with varchar of size m, o-times SELECT all rows (unbuffered), close. n, m, o vary.'; +$errors = array(); + +function mysqli_query_select_varchar_unbuffered($type, $len, $runs, $rows, $host, $user, $passwd, $db, $port, $socket, $flag_original_code) { + + $errors = $times = array(); + + foreach ($rows as $k => $num_rows) { + + foreach ($runs as $k => $run) { + + $times[$num_rows . ' rows: SELECT ' . $type . ' ' . $run . 'x overall'] = microtime(true); + + do { + if (!$link = @mysqli_connect($host, $user, $passwd, $db, $port, $socket)) { + $errors[] = sprintf("%d rows: SELECT %s %dx connect failure (original code = %s)", + $num_rows, $type, $run, ($flag_original_code) ? 'yes' : 'no'); + break 3; + } + if (!mysqli_query($link, "DROP TABLE IF EXISTS test")) { + $errors[] = sprintf("%d rows: SELECT %s %dx drop table failure (original code = %s): [%d] %s", + $num_rows, $type, $run, ($flag_original_code) ? 'yes' : 'no', mysqli_errno($link), mysqli_error($link)); + break 3; + } + + if (!mysqli_query($link, sprintf("CREATE TABLE test(id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, label %s)", $type))) { + $errors[] = sprintf("%d rows: SELECT %s %dx create table failure (original code = %s): [%d] %s", + $num_rows, $type, $run, ($flag_original_code) ? 'yes' : 'no', mysqli_errno($link), mysqli_error($link)); + break 3; + } + + $label = ''; + for ($i = 0; $i < $len; $i++) + $label .= chr(mt_rand(65, 90)); + + if (!$stmt = mysqli_stmt_init($link)) { + $errors[] = sprintf("%d rows: SELECT %s %dx stmt_init() for INSERT failed (original code = %s): [%d] %s", + $num_rows, $type, $run, ($flag_original_code) ? 'yes' : 'no', mysqli_errno($link), mysqli_error($link)); + break 3; + } + if (!mysqli_stmt_prepare($stmt, "INSERT INTO test(id, label) VALUES (?, ?)")) { + $errors[] = sprintf("%d rows: SELECT %s %dx stmt_prepare() for INSERT failed (original code = %s): [%d] %s", + $num_rows, $type, $run, ($flag_original_code) ? 'yes' : 'no', mysqli_errno($link), mysqli_error($link)); + break 3; + } + if (!mysqli_stmt_bind_param($stmt, "is", $i, $label)) { + $errors[] = sprintf("%d rows: SELECT %s %dx stmt_bind_param() for INSERT failed (original code = %s): [%d] %s", + $num_rows, $type, $run, ($flag_original_code) ? 'yes' : 'no', mysqli_errno($link), mysqli_error($link)); + break 3; + } + + for ($i = 1; $i <= $num_rows; $i++) { + if (!mysqli_stmt_execute($stmt)) { + $errors[] = sprintf("%d - $i rows: SELECT %s %dx insert failure (original code = %s): [%d] %s", + $num_rows, $type, $run, ($flag_original_code) ? 'yes' : 'no', mysqli_errno($link), mysqli_error($link)); + break 4; + } + } + mysqli_stmt_close($stmt); + + for ($i = 0; $i < $run; $i++) { + + if (!$stmt = mysqli_stmt_init($link)) { + $errors[] = sprintf("%d rows: SELECT %s %dx stmt_init() for SELECT failed (original code = %s): [%d] %s", $num_rows, $type, $run, ($flag_original_code) ? 'yes' : 'no', mysqli_errno($link), mysqli_error($link)); + break 4; + } + if (!mysqli_stmt_prepare($stmt, "SELECT id, label FROM test")) { + $errors[] = sprintf("%d rows: SELECT %s %dx stmt_prepare() for SELECT failed (original code = %s): [%d] %s", + $num_rows, $type, $run, ($flag_original_code) ? 'yes' : 'no', mysqli_errno($link), mysqli_error($link)); + break 4; + } + + $start = microtime(true); + $ret = mysqli_stmt_execute($stmt); + $times[$num_rows . ' rows: SELECT ' . $type . ' ' . $run . 'x stmt_execute()'] += (microtime(true) - $start); + + if (!$ret) { + $errors[] = sprintf("%d rows: SELECT %s %dx stmt_execute() SELECT failure (original code = %s): [%d] %s", + $rows, $type, $run, ($flag_original_code) ? 'yes' : 'no', mysqli_errno($link), mysqli_error($link)); + break 4; + } + + $id2 = $label2 = null; + if (!mysqli_stmt_bind_result($stmt, $id2, $label2)) { + $errors[] = sprintf("%d rows: SELECT %s %dx stmt_prepare() for SELECT failed (original code = %s): [%d] %s", + $num_rows, $type, $run, ($flag_original_code) ? 'yes' : 'no', mysqli_errno($link), mysqli_error($link)); + break 4; + } + + $start = microtime(true); + while (mysqli_stmt_fetch($stmt)) + ; + $times[$num_rows . ' rows: SELECT ' . $type . ' ' . $run . 'x stmt_fetch()'] += (microtime(true) - $start); + mysqli_stmt_close($stmt); + + } + + mysqli_close($link); + + } while (false); + + $times[$num_rows . ' rows: SELECT ' . $type . ' ' . $run . 'x overall'] = microtime(true) - $times[$num_rows . ' rows: SELECT ' . $type . ' ' . $run . 'x overall']; + + } + + } + + return array($errors, $times); +} + + +foreach ($types as $len => $type) { + list ($errors, $tmp_times) = mysqli_query_select_varchar_unbuffered($type, $len, $runs, $rows, $host, $user, $passwd, $db, $port, $socket, $flag_original_code); + $times = array_merge($times, $tmp_times); + if (!empty($errors)) { + break; + } +} + +// sort by labels +ksort($times); +?> Added: trunk/ext/mysqli/tests/bench/micro_benches/mysqli_stmt_fetch_many_columns_unbuffered.php =================================================================== --- trunk/ext/mysqli/tests/bench/micro_benches/mysqli_stmt_fetch_many_columns_unbuffered.php 2007-03-20 15:05:27 UTC (rev 210) +++ trunk/ext/mysqli/tests/bench/micro_benches/mysqli_stmt_fetch_many_columns_unbuffered.php 2007-03-20 15:09:00 UTC (rev 211) @@ -0,0 +1,143 @@ +<?PHP +// measured in KB, that means 1 = 1024 bytes +$columns = array(1, 3, 5, 10, 15, 20, 30, 40, 50, 100, 300, 500); +$column_types = array( + array("len" => 1, "name" => "c_tinyint", "type" => "TINYINT", "value" => 1), + array("len" => 2, "name" => "c_smallint", "type" => "SMALLINT", "value" => 1), + array("len" => 200, "name" => "c_varchar_199", "type" => "varchar(199)", "value" => "0123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678"), + array("len" => 3, "name" => "c_mediumint", "type" => "MEDIUMINT", "value" => 1), + array("len" => 20, "name" => "c_varchar_19", "type" => "varchar(19)", "value" => "0123456789012345678"), + array("len" => 4, "name" => "c_int", "type" => "INT", "value" => 1), + array("len" => 8, "name" => "c_bigint", "type" => "BIGINT", "value" => 1), + array("len" => 50, "name" => "c_varchar_49", "type" => "varchar(49)", "value" => "0123456789012345678901234567890123456789012345678"), + array("len" => 4, "name" => "c_float_24", "type" => "FLOAT(24)", "value" => 1), + array("len" => 150, "name" => "c_varchar_149", "type" => "varchar(149)", "value" => "1234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678"), + array("len" => 8, "name" => "c_float_25", "type" => "FLOAT(25)", "value" => 1), + array("len" => 4, "name" => "c_float", "type" => "FLOAT", "value" => 1), + array("len" => 8, "name" => "c_double", "type" => "DOUBLE", "value" => 1), + array("len" => 100, "name" => "c_varchar_99", "type" => "varchar(99)", "value" => "012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678"), + array("len" => 3, "name" => "c_date", "type" => "DATE", "value" => "2007-01-17"), + array("len" => 8, "name" => "c_datetime", "type" => "DATETIME", "value" => "2007-01-17 11:53:00"), + array("len" => 4, "name" => "c_timestamp", "type" => "TIMESTAMP", "value" => "2007-01-17 11:54:00"), + array("len" => 3, "name" => "c_time", "type" => "TIME", "value" => "11:54:00"), + array("len" => 1, "name" => "c_year", "type" => "YEAR", "value" => "2007"), + array("len" => 10, "name" => "c_char_10", "type" => "CHAR(10)", "value" => "0123456789"), + array("len" => 1, "name" => "c_enum", "type" => "ENUM('true', 'false')", "value" => "true"), + // let's assume latin1 + array("len" => 300, "name" => "c_varchar_99", "type" => "varchar(298)", "value" => "0123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567"), + ); +$rows = array(2000); + + +foreach ($rows as $k => $num_rows) { + foreach ($columns as $k => $num_columns) { + + $num_column_types = count($column_types); + $total_len = 0; + for ($i = 0; $i < $num_columns; $i++) { + $total_len += $column_types[$i % $num_column_types]['len']; + } + $times[$num_rows . ' row[s]: ' . $num_columns . ' column[s] (' . $total_len . ' bytes) overall'] = 0; + $times[$num_rows . ' row[s]: ' . $num_columns . ' column[s] (' . $total_len . ' bytes) fetch()'] = 0; + } +} +$description = 'Connect, create n-rows with one m-columns of different types, SELECT all (buffered), close. n and m vary.'; +$errors = array(); + +do { + + if (!$link = mysqli_connect($host, $user, $passwd, $db, $port, $socket)) { + $errors[] = sprintf("Connect failure (converted code: %s)\n", ($flag_original_code) ? 'no' : 'yes'); + break; + } + + foreach ($rows as $k => $num_rows) { + + foreach ($columns as $k => $num_columns) { + + if (!mysqli_query($link, "DROP TABLE IF EXISTS test")) { + $errors[] = sprintf("DROP TABLE failed (converted code: %s): [%d] %s\n", + ($flag_original_code) ? 'no' : 'yes', + mysqli_errno($link), mysqli_error($link)); + break 3; + } + + $num_column_types = count($column_types); + $total_len = 0; + $column_names = $column_defs = $column_values = ''; + for ($i = 0; $i < $num_columns; $i++) { + $index = $i % $num_column_types; + $total_len += $column_types[$index]['len']; + $column_names .= sprintf("%s_%d, ", $column_types[$index]['name'], $i); + $column_defs .= sprintf("%s_%d %s, ", $column_types[$index]['name'], $i, $column_types[$index]['type']); + $column_values .= sprintf("%s%s%s, ", + (is_string($column_types[$index]['value'])) ? '"' : '', + $column_types[$index]['value'], + (is_string($column_types[$index]['value'])) ? '"' : '' + ); + } + $last_column = sprintf("%s_%d", $column_types[$index]['name'], $i - 1); + $last_value = $column_types[$index]['value']; + + $sql = sprintf("CREATE TABLE test(%s)", substr($column_defs, 0, -2)); + if (!mysqli_query($link, $sql)) { + $errors[] = sprintf("%s failed (converted code: %s): [%d] %s\n", + $sql, + ($flag_original_code) ? 'no' : 'yes', + mysqli_errno($link), mysqli_error($link)); + break 3; + } + + $sql = sprintf("INSERT INTO test(%s) VALUES (%s)", substr($column_names, 0, -2), substr($column_values, 0, -2)); + for ($i = 0; $i < $num_rows; $i++) { + if (!mysqli_query($link, $sql)) { + $errors[] = sprintf("%s failed (converted code: %s): [%d] %s\n", + $sql, + ($flag_original_code) ? 'no' : 'yes', + mysqli_errno($link), mysqli_error($link)); + break 4; + } + } + + $times[$num_rows . ' row[s]: ' . $num_columns . ' column[s] (' . $total_len . ' bytes) overall'] = microtime(true); + + if (!$stmt = mysqli_stmt_init($link)) { + $errors[] = sprintf("stmt_init() failed (converted code: %s)\n", + ($flag_original_code) ? 'no' : 'yes'); + break 3; + } + if (!mysqli_stmt_prepare($stmt, 'SELECT * FROM test')) { + $errors[] = sprintf("stmt_prepare() failed (converted code: %s)\n", + ($flag_original_code) ? 'no' : 'yes'); + break 3; + } + if (!mysqli_stmt_execute($stmt)) { + $errors[] = sprintf("stmt_execute() failed (converted code: %s)\n", + ($flag_original_code) ? 'no' : 'yes'); + break 3; + } + + $row = array(); + $cmd = 'mysqli_stmt_bind_result($stmt, '; + for ($i = 0; $i < $num_columns; $i++) + $cmd .= sprintf('$row[%d], ', $i); + + $cmd = (substr($cmd, 0, -2) . ');'); + eval($cmd); + + $start = microtime(true); + while (mysqli_stmt_fetch($stmt)) + ; + $times[$num_rows . ' row[s]: ' . $num_columns . ' column[s] (' . $total_len . ' bytes) fetch()'] += (microtime(true) - $start); + + mysqli_stmt_close($stmt); + $times[$num_rows . ' row[s]: ' . $num_columns . ' column[s] (' . $total_len . ' bytes) overall'] = microtime(true) - $times[$num_rows . ' row[s]: ' . $num_columns . ' column[s] (' . $total_len . ' bytes) overall']; + + } + } + + + mysqli_close($link); + +} while (false); +?> \ No newline at end of file
| Thread | ||
|---|---|---|
| • PHP mysqlnd svn commit: r211 - trunk/ext/mysqli/tests/bench/micro_benches | uwendel | 20 Mar |
© 1995-2008 MySQL AB, 2008-2009 Sun Microsystems, Inc.
Page generated in 0.948 sec. using MySQL 5.1.14-beta-log