PHP MySQL Insert Rows Limit

Question

Currently I have a PHP script that inserts about 2000+ rows into the mysql database.

But for my case it stops after 500+ rows. Any idea what could be the issue?

I have verified by also displaying out the data before insertion and it shows all the 2000+ rows of data.

Came across this posting MySQL insert limit? but I am currently using MySQL in Windows.

How could I remove the limit?

Your page seems getting time out.Try adding set_time_limit(0); in your code. — Rikesh
– Rikesh, Commented Mar 18, 2013 at 10:02

Php Geek · Accepted Answer · 2013-03-18 10:02:36Z

5

This happens because of the time limit exceeding 30 sec.... To overcome this , you can follow either the following steps

1. Use this code 
 set_time_limit(0);
 in your php before inserting into db

or

2. Change the time limit in your php.ini file ...

1 option is better and temperory measure though

answered Mar 18, 2013 at 10:02

Php Geek

1,1071 gold badge15 silver badges38 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Sanket Shembekar · Accepted Answer · 2013-03-18 10:16:25Z

0

Open Php.ini and go to line no. 442. You will get following line

  max_execution_time = 30

set max_execution_time to "0" which is means no limit or set other value in seconds

answered Mar 18, 2013 at 10:16

Sanket Shembekar

2981 gold badge4 silver badges9 bronze badges

Fasil Palanthodi · Accepted Answer · 2019-11-08 08:51:04Z

0

You can put this PHP code before inserting into the database

ini_set('max_execution_time', -1);
ini_set('memory_limit', -1);

answered Nov 8, 2019 at 8:51

Fasil Palanthodi

3022 silver badges8 bronze badges