James Smith wrote: > > In CF and that takes about a second, so why is it taking 1:15 for MSSQL do > do it in one operation? >
One thing to keep in mind is that the SQL you write and send to SQL Server is being interpreted by their query optimization code...which is written by humans and fallible...generally it works real well, but there are a lot of moving parts with SQL...and sometimes the optimization does just the opposite. I've had queries that returned in a couple seconds go up to a couple of minutes with the application of certain service packs with optimization code "upgrades" (much more of an issue with SQL 7). One more vote for reviewing the execution plan...it may give you insight into the mind of the optimizer. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:255384 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
