Changed it to a UNION ALL and still taking 32 seconds. By letting CF combine the data you mean drop the two queries into an array? Would this be a good time to switch to a full SQL server, if so any suggestions I use access because it is easy to use.
Travis Haley Haley Computer Solutions 2749 E. Nichols Cir Centennial, CO 80122 P: (303) 694-8050 F: (303) 779-0335 -----Original Message----- From: Brad Wood [mailto:[EMAIL PROTECTED] Sent: Friday, September 21, 2007 1:34 PM To: CF-Talk Subject: RE: table union 23ms to run the whole page -------------------------- Wow-- does Access support "UNION ALL" Be default union usually eliminates duplicate records returning you a distinct list. The overhead might be in the comparison of each record. Once again I don't know if that applies to Access. Either way, using some sort of temp table to select into would eliminate the union all together. You could combine the results in CF, but it is probably best to let the DB do that kind of work in theory. ~Brad ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289154 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
