title: Coldfusion CFQUERY time limit exceeded
body: <p>I have a saved XML file which is 7.1mb and contains over 1000 properties and all the info for those properties. My cfscript parses and then inserts the properties into the property table along with features and image URLs to their respective tables.</p>
  
  <p>However, the process bombs out usually after it has passed 250 records and then gives me this error:</p>
  
  <pre><code> The request has exceeded the allowable time limit Tag: CFQUERY 
  </code></pre>
  
  <p>I have put a timeout value of 9000000 in my cfquery tag and that does nothing. I don't know what else to do to resolve this.</p>