> I'm not a SQL expert, by any means, but wouldn't it run > faster if you optimized your 'JOIN's a little bit? Seems like > you're leaving it up to SQL, right now, to determine on the > fly whether you need an INNER, OUTER, LEFT or RIGHT JOIN? You > know your data structure, so you should be able to figure out > which type of JOIN is necessary in each statement. > By explicitly defining it you decrease the server overhead > because it doesn't have to figure it out for you.
I wasn't hopefull but I tested it anyway, still takes under a second without the DISTINCT and the exact same 1:15 with it. -- 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:255363 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4