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 is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finder&productID=1522&loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289137 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
