codepad
[
create a new paste
]
login
|
about
Language:
C
C++
D
Haskell
Lua
OCaml
PHP
Perl
Plain Text
Python
Ruby
Scheme
Tcl
#!/usr/bin/php -q <?php /***************************************** "help large_table" output: Name: large_table Owner: ingres10 Created: 12-aug-2009 18:15:22 Type: user table Version: II9.0 Column Information: Key Column Name Type Length Nulls Defaults Seq id integer 4 no identity 1 email varchar 32 yes null ********************************************************************/ function genRandomString() { $length = 14; $characters = "0123456789abcdefghijklmnopqrstuvwxyz"; $string = ""; for ($p = 0; $p < $length; $p++) { $string .= $characters[mt_rand(0, strlen($characters)-1)]; } return $string; } //getRandomString() $every = 1000; $count = 0; $numQueries = 100; $qc = 1; $dbc = ingres_connect("school", "ingres10", "changeme"); if (is_resource($dbc)) { echo "Connection succeeded.\n"; for ($i = 0; $i < 100000000; $i++) { $sql = "insert into large_table(email) values (?)"; $email = genRandomString() . '@' . genRandomString() . ".eu"; $params = array($email); $res = ingres_query($dbc, $sql, $params); if (!is_resource($res)) { trigger_error(ingres_error(), E_USER_ERROR); die("failure."); } ingres_commit($dbc); /* if ($qc == $numQueries) { ingres_commit($dbc); $qc = 1; } else { ++$qc; } // else */ ++$count; if ($count == $every) { echo $email , "\n"; // echo strlen($email), "\n"; $count = 0; } // if } // for // final commit } else { trigger_error(ingres_error(), E_USER_ERROR); } // else ?>
Private
[
?
]
Run code
Submit