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.

[Son Nguyen]

Probably you need to provide more details (the schemas, how you parse/import the rows) for anyone to help. W/o the info, I'd say 15mins for about 100Mb is inefficient.