It is really easy for CF using QoQ, since the heavy lifting was already done by sql. The results of your first query was already there for CF to play with, and it did not have to go back to sql for more results. Anyway, that is why is is faster for CF sometimes.
----- Original Message ----- From: "James Smith" <[EMAIL PROTECTED]> To: "CF-Talk" <[email protected]> Sent: Wednesday, October 04, 2006 5:08 AM Subject: RE: Another MSSQL issue, why is DISTINCT so slow? > What makes this silly is that if I run the query without the DISTINCT it > takes a fraction of a second to return a couple of thousand rows. I can > then do a... > > <cfquery name="getGenres" dbtype="query"> > SELECT DISTINCT GenreDisplayName,GenreDisplayID > FROM getGenres > </cfquery> > > In CF and that takes about a second, so why is it taking 1:15 for MSSQL do > do it in one operation? > > -- > Jay > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:255373 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
