> I had always presumed that a Stored Procedure ran faster than a SQL
query...
> the problem is that when I actually run speed tests, it's about the same
> speed...
did you try running the sp w/cfquery? in any case, the sp will
get faster in the long run.
> And NOT R.RequestId In (Select distinct t.RequestId
> From TaskEffort as te, task as t
> where Te.taskid=t.task)
> order by r.DateEntered
this is a bear. have you tried NOT EXISTS instead?
> There are indexes in place where I can, but it's just damn confusing why
the
> SP runs slower than the SQL...
have you let the index wizard at this? got a clustered index?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
