title: different between cfstoredproc and cfquery
body: <p>I've found previous programmers using cfstoredproc in our existing project about insert records into database.</p>
  
  <p>Just example he/she used like that:</p>
  
  <pre><code>&lt;cfstoredproc procedure="myProc" datasource="myDsn"&gt;
      &lt;cfprocparam type="In" cfsqltype="CF_SQL_CHAR" value="ppshein" dbvarname="username"&gt;
      &lt;cfprocparam type="In" cfsqltype="CF_SQL_CHAR" value="28 yrs" dbvarname="age"&gt;  
  &lt;/cfstoredproc&gt;
  </code></pre>
  
  <p>I can't convince why he/she used above code instead of:</p>
  
  <pre><code>&lt;cfquery datasource="myDsn"&gt;
      insert usertb
      (name, age)
      values
      (&lt;cfqueryparam cfsqltype="CF_SQL_CHAR" value="ppshein"&gt;, &lt;cfqueryparam cfsqltype="CF_SQL_CHAR" value="28 yrs"&gt;)
  &lt;/cfquery&gt;
  </code></pre>
  
  <p>I feel there will be the hidden performance using cfstoredproc and cfquery for complex data manipulation. Please let me know the performance using cfstoredproc in coldfusion instead of cfquery for complex data manipulation. What I know is <strong>reusable</strong>. </p>