Welcome to WebmasterWorld Guest from 22.214.171.124
if use php's feature to count the number of lines of the file using explode, it still returns the exact lines (20,000+) but if it gets to the part when putting it into the db, it cuts the lines into 3,000+ lines only.
I cannot detect if the problem is with php or mysql.
help!. thanks. =)
The script execution time is 60 sec in php, however, when I try to put the webserver and mysql to a zeon machine, the problem was solved. (?!?) the previous machine that is having the problem is celeron. Hardware problem or configuration?
Well, if it's executed on a box with a faster processor, the process time will be shorter (and will probably be under 60 seconds)