[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 365
  • Last Modified:

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
0
wal_toor
Asked:
wal_toor
1 Solution
 
dwaynecharringtonCommented:
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

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now