Home>Article>Backend Development> What are the solutions to memory overflow when importing big data into phpexcel?
PHPExcel version: 1.7.6
Without special settings, phpExcel will save the read cell information in memory , we can set different caching methods throughPHPExcel_Settings::setCacheStorageMethod()
, which has achieved the purpose of reducing memory consumption!
Recommended video tutorials:php introductory tutorial
Solution:
1. Serialize the cell data and save it in memory Medium
PHPExcel_CachedObjectStorageFactory::cache_in_memory_serialized;
2. Serialize the cells and then Gzip compress them, then save them in memory
PHPExcel_CachedObjectStorageFactory::cache_in_memory_gzip;
3. Cache them temporarily disk file, the speed may be slower
PHPExcel_CachedObjectStorageFactory::cache_to_discISAM;
4. Save in php://temp
PHPExcel_CachedObjectStorageFactory::cache_to_phpTemp;
5. Save in memcache
PHPExcel_CachedObjectStorageFactory::cache_to_memcache;
$cacheMethod = PHPExcel_CachedObjectStorageFactory::cache_to_memcache; $cacheSettings = array( 'memcacheServer' => 'localhost', 'memcachePort' => 11211, 'cacheTime' => 600 ); PHPExcel_Settings::setCacheStorageMethod($cacheMethod, $cacheSettings);
Note that it is added in front ofnew PHPExcel()
, as follows:
require_once APPPATH .'third_party/PHPExcel/PHPExcel.php'; $cacheMethod = PHPExcel_CachedObjectStorageFactory::cache_to_phpTemp; $cacheSettings = array('memoryCacheSize'=>'16MB'); PHPExcel_Settings::setCacheStorageMethod($cacheMethod, $cacheSettings); $objPHPExcel = new PHPExcel();
Recommended related article tutorials:php tutorial
The above is the detailed content of What are the solutions to memory overflow when importing big data into phpexcel?. For more information, please follow other related articles on the PHP Chinese website!