is it normal for mysql to take 14+ seconds to do something simple like (pseudecode) for x = 10000 to 20000; mysql_query(insert into users (muser) values ($x)) ???
muser is varchar, length 5, non primary (it is the only column in the table)
I am on a AMD Athlon 64 3500+ PC with 1gb ram.. this is all being done locally
the exact code im using is below
Code:
$dbcnx = mysql_connect('localhost','xxxxx', 'xxxxx');
mysql_select_db("testtable", $dbcnx);
for ($i = 10000; $i <= 20000; $i++) {
mysql_query("insert into users (muser) values ('$i')");
}