How long doest it take to insert 100MB datas in PHP

[perumal]

Hi,

I wrote a php program to read and parse apache log file.The size of the log file is 100MB.

From that i collected 70MB datas.

I tried to insert this data into mysql database ,it takes hardly 15 minutes to finish the job.

Is this timing is correct?

or

ist possible to reduce the time?


please help me..........

Thanks
Perumal.

[mushroom]

There is not much of anything that can not be improved, this applies to scripts as well.

With out seeing your code or knowing the speed of all you computer parts no one came say if you time is excessive.

I had a proscess (php/mysql) that took 10 mins, rewrote it down to 90 sec, then rewrote it down to less than 10 sec.