I try to create Excel file with 13 sheets each of it consist of 200 rows and 5-20 columns
If I do it without any caching then memory consumption would be 30.25 mb. To reduce the amount of memory I'm trying to use file caching, particular cache_to_phpTemp method. After that I receive reduce memory amount on the local server till 8mb. But then
I do the same caching on the remote server then I receive reducing only till 23.25 MB regardless of the setting $cacheSettings = array( ' memoryCacheSize ' => '1MB');
The same memory consumption (23.25 MB) I receive if I use cache_to_discISAM method.
1. How can this be explained? What PHP settings may affect this?
2. is it possible to change the path for temporary files and how to do this?
3. Please advice if you know more effective method of memory reduce.
Thanks in advance.