Re: The search is killing the server. Please help!

[G]

I've always used CFQUERY as well when executing stored procedures.....but you've got me wondering, is there a performance hit that occurs here? Or are there other distinct advantages to using CFSTOREDPROC tag?

Brian
  ----- Original Message -----
  From: Micha Schopman
  To: CF-Talk
  Sent: Thursday, July 29, 2004 9:09 AM
  Subject: RE: The search is killing the server. Please help!

  You have 2 options,

  Use cfquery to execute the stored procedure (I prefer this method, much
  better readable instead of that ugly cfstoredproc tags) and then cache
  it. Or define a sql code based variablename based on the parameters in
  the sql to store the data into an application variable.
  Micha Schopman
  Software Engineer
  Modern Media, Databankweg 12 M, 3821 AL  Amersfoort
  Tel 033-4535377, Fax 033-4535388
  KvK Amersfoort 39081679, Rabo 39.48.05.380

---

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

---