title: Handling large data in php
body: <p>I am trying to insert large data into db after mls property search(<a href="https://github.com/troydavisson/PHRETS" rel="nofollow">PHRETS</a>)
  . The result object have around 4500 to 5000 records each having 450-475 keys,
  it gives "HTTP Error 500 Internal server error" while inserting data into db after sometime(generally after 6-7 min)  because of time limit of server I guess, I asked server guys to increase the time limit for execution, still it gives error</p>
  
  <p>here is the process of my execution</p>
  
  <p>1)I make search into mls for properties</p>
  
  <p>2)I try to insert all records at once using Implode to save execution time</p>
  
  <pre><code>$qry=mysqli_query($link,"INSERT INTO `rets_property_res` VALUES implode(',', $sql)");
  </code></pre>
  
  <p>-tried using prepared statements</p>
  
  <p>can we store this data somewhere and then later process it at once  OR can we speed up the process to make everything work in given timeframe</p>