filesize of function.fgetcsv.php

I really would like to use the fgetcsv function in a php application. The thing is that my csv file contains 6 million unique codes and has a 36 Mb filesize. Does fgetcsv handles files this big? Or is there a better solution?

Greetz,
walter
LVL 8
wal_toorAsked:
Who is Participating?
 
dwaynecharringtonConnect With a Mentor Commented:
I'm fairly certain that this function will open that CSV file fine. I don't think there is a specific limit on the file size.

If you're unsure, check this link out. It explains the function well:
http://theserverpages.com/php/manual/en/function.fgetcsv.php
0
 
hampus_bCommented:
No problems. Just don't read it all in one statement, but parse it line by line (as fgetcsv is supposed to work).
0
 
wal_toorAuthor Commented:
Hello all,

@dwaynecharrington
I have tried this solution, it works. After doing some searching there was even a faster solution: using LOAD DATA LOCAL INFILE 1.3 million records within a few seconds... amazing.

Thanks for your comment.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.