title: how to handle large sets of data with PHP?
body: <p>My web application lets user import an excel file and writes the data from the file into the mysql database.
  The problem is, when the excel file has lots of entries, even 1000 rows, i get an error saying PHP ran out of memory. This occurs while reading the file.
  I have assigned 1024MB to PHP in the php.ini file.</p>
  
  <p>My question is, how to go about importing such large data in PHP.</p>
  
  <p>I am using CodeIgniter. 
  for reading the excel file, i am using <a href="http://code.google.com/p/php-excel-reader/" rel="nofollow">this</a> library.</p>
  
  <hr>
  
  <p>SOLVED. I used CSV instead of xls. and I could import 10,000 rows of data within seconds.
  Thank you all for your help.</p>