I use the phpexcel library from codeplex to export a large amount data to an excel file (2007).
The problem is that takes much time to be executed... I used the memory cache options and cache dir options that exist as part of the library and I have unset the objects after the data is returned.
also I feel I should note that in my application I use some variables to count the rows included in the loop.
Any idea or concept to make the script faster or more efficient would be wonderful.