MySQL Forums
Forum List  »  Perl

Re: Why I can't insert more than 100,000 rows in a script?(mysql+php)
Posted by: Rick James
Date: September 09, 2015 06:11PM

I doubt seriously if MySQL is the 'problem'.

PHP from a browser? Did it hit php's default timelimit?

It will run a lot faster if you insert multiple rows with one insert. However, that takes extra code.

Got error message?

Did it insert some of the rows?

Which Engine are you using?

Don't use the deprecated mysql_* interface, use mysqli_* or PDO.

Options: ReplyQuote


Subject
Written By
Posted
Re: Why I can't insert more than 100,000 rows in a script?(mysql+php)
September 09, 2015 06:11PM


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.