No arrays necessary. You should be able to union the two result sets with a query of queries after running them separately.
The database _should_ always be the fastest way to do that, but obviously there are some other factors at work here and I don't know how to trouble shoot them... If you have SQL server sitting around and you are just waiting to use it-- heck go for it. It's always harder to switch later. I don't know that I would spend the money just for the heck of it unless you definitely need some of its functionality or you are planning on having a pretty big database by the time you are done with app. I used to do all my personal stuff in Access because it was all I had. I've worked for 3 1/2 years with MS SQL 2000 and 2005 now and I don't think I could go back now that I am used to it. ~Brad -----Original Message----- From: Travis Haley [mailto:[EMAIL PROTECTED] Sent: Friday, September 21, 2007 5:10 PM To: CF-Talk Subject: RE: table union 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. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289155 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
