allow it to be created, then the SQL is pre-compiled, while sending a
fresh bit of SQL to the server has to be compiled at that time
Theoretically the View should be faster - but YMMV!
The only way to guarantee what your results will be is to test it
yourself
Rember that a good index can make a HUGE difference on a query, a lot
bigger than just changing it to a View, but changing it might make an
additional increase
-----Original Message-----
From: admin [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 09, 2003 3:03 PM
To: CF-Talk
Subject: cfquery vs sql view
I was wondering if anyone knew which was more efficient (ie faster)
doing the select logic like :-
where catagory='catagory name'
in a cfquery or doing it in a sql 2000 database view ?
Cheers
Richard
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
