Go to Topic: Previous•Next
Go to: Forum List•Message List•New Topic•Search•Log In•Print View
Inserts into the database
Posted by: aiddma (---.hsd1.ma.comcast.net)
Date: February 06, 2009 03:18AM

Can someone please tell me the limit of records I can insert at a time in the mysql database? my computer crashed when I tried to insert 13,000 rows at a time

Options: Reply•Quote
Re: Inserts into the database
Posted by: stevenmartin99 (193.120.116.---)
Date: February 06, 2009 06:19AM

there is no real limit except to the overal size of the limit.. I reguarly do over 100000 in one go , never a problem. Are u getting an error such as max execution time?

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]

Options: Reply•Quote
Re: Inserts into the database
Posted by: aiddma (---.hsd1.ma.comcast.net)
Date: February 06, 2009 01:55PM

nope. My laptop just shut down !! can you believe it?? it happened twice.

Options: Reply•Quote
Re: Inserts into the database
Posted by: stevenmartin99 (---.b-ras1.blp.dublin.eircom.net)
Date: February 06, 2009 02:22PM

keep task manager open on the performance tab.. see if the graphs changed as its inserting

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]

Options: Reply•Quote
Re: Inserts into the database
Posted by: aiddma (---.hsd1.ma.comcast.net)
Date: February 06, 2009 07:55PM

Steven,

I had a syntax error in my query which was causing my laptop to crash. Now I am getting this error:

Fatal error: Maximum execution time of 300 seconds exceeded in C:\wamp\apps\phpmyadmin3.1.1\libraries\sqlparser.lib.php on line 355.

Of course, I checked line 355, nothing unusual, same as the other lines.

Options: Reply•Quote
Re: Inserts into the database
Posted by: stevenmartin99 (---.b-ras1.blp.dublin.eircom.net)
Date: February 06, 2009 08:12PM

you will need to change the max executioin time of php to allow scripts run more then 300 seconds.


if you own the script then add

set_time_limit(00);

as the very first line in script that is accessing mysql



otherwise chnage the php.ini file (left click wamp icon >PHP> php.ini

find and change

max_execution_time = 30 ; Maximum execution time of each script, in seconds

to


max_execution_time = 00 ; Maximum execution time of each script, in seconds


Save the file and restart wamp.


You should change this back after you import it if you dont need that kind of time again.

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]

Options: Reply•Quote
Re: Inserts into the database
Posted by: newseed (---.pn.at.cox.net)
Date: February 06, 2009 08:17PM

Ah! That's good to know! Thanks!

Options: Reply•Quote


Go to: Forum List•Message List•Search•Log In
Sorry, only registered users may post in this forum.
Click here to login