Excel & CSV Export - server memory pressure

(2 posts) (2 voices)
  1. Team,

    I know the recommendation is not to export large of amounts of detailed data. However, some of our internal groups want this ability and do not mind waiting.

    One thing I have noticed is that trying to export 10k rows or more of more than a few columns causes apache threads to consume well over 600MB of memory. I've increased both the timeout and memory parameters for PHP to accomodate this.

    However, with multiple concurrent users, our server's memory can easily come under great pressure with concurrent exports.

    I realize the memory is likely an issue within PHPExcel. Have you tested any of the other PHPExcel_CachedObjectStorageFactory settings?

    I'd be happy to test locally if it's a user-configurable.

    Also, is there any chance of using something else to generate csv output besides PHPExcel given its performance issues?


    PS Also I'm assuming that optimizations described here and here have already been attempted or looked at?

  2. myDBR Team, Key Master

    PHPExcel consumes a lot of memory and processing power. We're currently considering replacing this with something more suitable.

    myDBR Team


You must log in to post.