High volume of inserts

[thody]

I'm working on a pretty simple log analyzing stat app, and I've come to a point where I will need to make a large volume (2000+) of inserts into a mysql database.

Is there a way I can do this without crashing my server?

Any input would be great.

Cheers,
Adam

[raf]

I have recently ran a dumpfile that include almost 62000 inserts.
It took a few minutes but everything was fine (just on a PII with 196 RAM)

2k records should be no problem.
If you would do this with phpmyadmin, then maybe your script would timeout, but it's not very likely with such a low amount.
If yoy can, do it through the commandline or through a db-front that doesn't go over the webserver, so your not waisting resources there.

[thody]

Wow...that's a lot of inserts lol.

Ok, thanks for the heads up, I'll give it a try locally I guess.

Cheers