Reading csv file (30MB)

[renjithv]

Hi All

I have large csv file (30MB) . I want to insert the contents to multiple tables. I tried this using fgetcsv() to read the csv file, but it takes large amount of time. If u know any other method Please help me.

Thanks

[triexa]

I've never worked with files that large, but there is also file_get_contents, file, and fopen.

With fopen you could just fread it a bit at a time

[kyberfabrikken]

With such large files, you shouldn't load all data into memory at once.

See this thread: http://www.sitepoint.com/forums/showthread.php?t=452031