Yes cfstoredproc is supposed to be faster...I beleive I read/heard
somewhere that cfstoredproc only takes 3 steps to exectute everything
and cfquery requires something like 10 steps(might have been a
dream)...I have not seen a difference generally.

Adam H

On Thu, 29 Jul 2004 16:21:16 +0200, Micha Schopman
<[EMAIL PROTECTED]> wrote:
> I always have used cfquery, according to Macromedia document
> cfstoredproc should be faster, but I've only seen the opposite being
> true. Like it is important though if one function is 0.00001 ms faster
> than the other function ;)
>
> I prefer cfquery because it makes my code more readable, and I see no
> reason to use cfstoredproc unless multiple datasets are returned.
> 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]

Reply via email to