MySQL Forums
Forum List  »  Perl

Why I can't insert more than 100,000 rows in a script?(mysql+php)
Posted by: Anghel Cojan
Date: March 23, 2008 04:35PM

Hello!
I'm having a script for inserting a number of rows into a mysql table.
it goes something like this

$i=0;
while ($i<300000)
{
$x=rand(1,58000);
echo "I'm inserting number $i - amount $x <br />";
$query="INSERT INTO sales (amount) values('$x')";
mysql_query($query) or die(mysql_error());
$i++;
}

The script works well , but the problem is that it has a limit of aprox 100,000 rows per call.
Why can't I insert more than 100,000 rows?Can somebody explain me?

(I'm using MYSQL 5.0.51a Community Edition)
Thank you very much.

Options: ReplyQuote


Subject
Written By
Posted
Why I can't insert more than 100,000 rows in a script?(mysql+php)
March 23, 2008 04:35PM
April 30, 2008 04:01AM
August 30, 2008 03:24PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.