Jump to content

Archived

This topic is now archived and is closed to further replies.

Koobi

whats a safe number of MySQL inserts -

Recommended Posts

hey,

i'm writing a script that filters some text for some data and then writes out an SQL file which contains an INSERT command to enter that filtered data into a MySQL database.

 

i want to know, how many INSERTS is it allright to make in one go via phpMyAdmin?

there may be upto 10,000 entries i want to insert, but phpMyAdmin would probably timeout before all of them are made so i want to break it up into multiple SQL scripts.

 

 

the user who will be handling this is running FreeBSD on a relatively fast machine using the latest version of phpMyAdmin.

 

if there's an alternative, such as MySQL CLI that won't time out with around 10,000 records, then feel free to make such a suggestion but give me an idea as to how i can do it because when it comes to MySQL, my knowledge is severely limited :/

 

thanks guys

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.