I had try to use cell caching , so i need help , cause i dont know do i make mistake on my side or this class has some problem.
Here i give short sample of my script :
$cacheMethod = PHPExcel_CachedObjectStorageFactory:: cache_to_phpTemp; //PHPExcel_CachedObjectStorageFactory::cache_to_discISAM ; //
$cacheSettings = array( 'memoryCacheSize' => '32MB');
$objReader = PHPExcel_IOFactory::createReader('Excel2007');
$objPHPExcel = $objReader->load("mega_list.xlsx"); // my file has 10 columns and 25200 rows
I have a box with 2 GB ram only , i have free for use 1.4 GB. I will use this so that i use so low memory as possible
So i have following problems :
1.) What Caching method should i use (speed is not so importaint)
2.) What means "memoryCacheSize"=>"32MB" ? I have understand if memory usage is greater than "32MB" rest will be stored in file on disk ? If this is right i have problem that the script try to use all my memory what i have
3.) After my script has finished, it would be aprox. 350MB RAM memory not freed , it goes to NIRVANA somewhere in APACHE2, even after 1 Hour the memory is not freed. I must restart my apache to get this memory free , if my customers start this script few
times , i must reboot my box
What could be here wrong ?