MySQL Forums
Forum List  »  Perl

Why I can't insert more than 100,000 rows in a script?(mysql+php)
Posted by: Bhupendra Chouhan
Date: September 08, 2015 08:12AM

Hi,

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?

Options: ReplyQuote


Subject
Written By
Posted
Why I can't insert more than 100,000 rows in a script?(mysql+php)
September 08, 2015 08:12AM


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.