Re: Efficiently parsing a File

Tiago Hori wrote: > I am looking at all your suggestions. The file has 9216 entries with > 10 columns, but I only need 2 of them really. > > The crucial one, is the one that I have to split with explode using > the “: “ separator. > > The files are about 1MB, that’s why I reached out, I figured it > shouldn’t take that long. I still presume the performance problem is due to the many separate insert statements (reading such files with fgets() isn't the problem). There is an article regarding the speed of insertions in MySQL databases, with several optimization suggestions: <https://dev.mysql.com/doc/refman/5.7/en/insert-speed.html> HTH -- Christoph M. Becker