Lowest memory caching method for PHPExcel

Question

I tried using various caching methods in section 4.2.1 of the PHPExcel manual.

made a mark with 100k lines and here are the results

gzip = time=50,memoryused=177734904
ser  = time=34,memoryused=291654272
phptm= time=41,memoryused=325973456
isamm= time=39,memoryused=325972824

The manual says that the phptmp and isamm methods use a disk instead of memory. Therefore, they should use the least memory, but it seemed to be the other way around.

Here is the code I used for testing:

                $cacheMethod = PHPExcel_CachedObjectStorageFactory::cache_in_memory_gzip;
//              $cacheMethod = PHPExcel_CachedObjectStorageFactory::cache_in_memory_serialized;
//              $cacheMethod = PHPExcel_CachedObjectStorageFactory:: cache_to_phpTemp;
//          $cacheSettings = array( 'memoryCacheSize'  => '8MB');               
//              $cacheMethod = PHPExcel_CachedObjectStorageFactory:: cache_to_discISAM;

                PHPExcel_Settings::setCacheStorageMethod($cacheMethod, $cacheSettings);

                $xlsReader = PHPExcel_IOFactory::createReader($fileType);
                $xlsReader->setReadDataOnly(true);

Can anyone shed light on this mystery?

Answer 1

, PHP, (, , ..), PHP ..; , , , .

, SQLite, SQLite .

PHP ,

, , discisam phptemp, , phptemp, ; , , .