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: August 30, 2008 03:18PM

1. The inserts will go much faster if you batch them:
INSERT INTO tbl (x) VALUES (1),(22),(999);

2. PHP, unlike Perl, is not good at long-running scripts; it often has memory leaks that cause it to crash.

Options: ReplyQuote


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


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.