On 10/4/06, James Smith <[EMAIL PROTECTED]> wrote: > In CF and that takes about a second, so why is it taking 1:15 for MSSQL do > do it in one operation?
Theoretically, that's what query analizers are for. Shooting from the hip, I'll second the index suggestion. Shooting from the head, I'll second the execution plan* checking suggestion. *EXPLAIN SELECT blah.baah blah.baaah (IIRC, if it fits the db.) =] There is webinfo on how to read this info and maximize your speed too. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:255377 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4