On Tue, Oct 5, 2010 at 12:39 AM, chris h <chris404@xxxxxxxxx> wrote: > I'm currently working on a project that requires the parsing of excel files. > ÂBasically the user uploads an excel file, and then a script needs to save a > row in a Postgres database for each row in the excel file. ÂThe issue we are > having is that when we task PHPExcel with parsing an excel file with, say > 27k rows, it explodes with a memory error. ÂI've read up on the PHPExcel > forums and we've tried cell caching as well as ReadDataOnly, they do not > seem to be sufficient. > > Does anyone here know of a way to do this? Surely there is a way to parse a > large excel file with PHP. ÂThis is also NOT an on-demand service. ÂThat is, > when someone uploads a file they get a task_id which allows them to check > the status of their excel file. ÂSo the solution does not need to be a fast > one! > > > Thanks, > Chris. > 1. Remove any variable that contains big object if its not necessary. 2. Use unset when applicable 3. Read chunk by chunk. 4. Profile it to find the exact place where you are wasting memory. Optimizing that little portion of code can improve memory performance. -- Shiplu Mokadd.im My talks, http://talk.cmyweb.net Follow me, http://twitter.com/shiplu SUST Programmers, http://groups.google.com/group/p2psust Innovation distinguishes bet ... ... (ask Steve Jobs the rest) -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
