Re: Efficiently parsing a File

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Jim and Christoph,

Thanks!

>> 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
> 

So, I could use Jim suggestion, but maybe not add the whole 9000 entries of time, correct? Would it be a good solution to create separate arrays with every 500 rows or just create one big array like Jim suggested and then break the insertion into iterations of 100 rows?

Thanks!

T,




> -- 
> Christoph M. Becker
> 
> 


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php






[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux