Loading times

Topics: Developer Forum, Project Management Forum, User Forum
Feb 3, 2010 at 10:23 PM

I've been playing around with PHPExcel for a couple of days now and am seeing a load time of sometimes 10 secs to load an Excel 2007 document of a relatively small size into memory (14kb and 12 columns by 34 rows).  Is there anyway I can reduuce this load time?  Also, I've noticed that it takes an average of 4 seconds to load a PHP file which only contains the below code.  The delay comes from the 'include' line.

<?php
/** Error reporting */
error_reporting(E_ALL);

/** Include path **/
ini_set('include_path', ini_get('include_path').';../Classes/'); //Classes dir

/** PHPExcel_IOFactory */
Include '../Classes/PHPExcel/IOFactory.php';
?>

Does anybody else experience this?  I am grateful for any advice on this matter.

Coordinator
Feb 3, 2010 at 10:38 PM

That really is incredibly slow. What type of platform are you running on? My development box (which isn't particularly powerful) will load a xlsx workbook comprising 2 worksheets of 3.5k rows by 15columns (186k in size) in about 2 seconds.

With regard to the include line: the latest Subversion code for PHPExcel includes a "lazy loader" that only loads classes when they're actually required. This reduces the memory used by PHPExcel, and also reduces load/save time for a typical workbook.