whats not being asked is how big is the dataset, what type of hardware, how do you know its running slow? compared to what?
I mean if you have a million records on a Pentium 2 with 128m of ram, your going to have less then average response time. also are the CF server and DB server on the same LAN? I think the sql statement you have is just about as straight forward as you are going to get. how long does a straight SELECT * FROM F INNER JOIN M taking?? -----Original Message----- From: Kris Jones [mailto:[EMAIL PROTECTED] Sent: Monday, April 02, 2007 11:43 To: CF-Talk Subject: Re: OT: SQL Question How about something like this: SELECT F.pid, F.acrostic, F.recid, F.recordthread, F.aed_onset, F.d_form FROM vfrm_sae F WHERE NOT EXISTS (SELECT 1 FROM v_sae_jna_mr WHERE recid=F.recordthread) Not sure it'll be much faster, but it's worth a try. Cheers, Kris > The following query is slow. I'd like to speed it up a bit. Any > suggestions would be appreciated. > > SELECT > F.pid, > F.acrostic, > F.recid, > F.recordthread, > F.aed_onset, > F.d_form > FROM > vfrm_sae F > LEFT OUTER JOIN > v_sae_jna_mr M > ON > F.recordthread = M.i_recordThread > WHERE > (M.i_recid IS NULL) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274329 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
