That makes sense, you have several IN statements and without knowing much about your app, I'd say based on the names in your IN statements, you may have a lot of them. ZIPCODES, CITIES and STATES could be very large lists...
That many lists in 3 different IN statements tied together using ORs... I could see that choking a SQL server. You may want to look into to do some JOINS off of those fields and combining some queries, you'll get a huge performance boost. I can't offer much more based on what little code is there. How deep are you into this project? It may be necessary to do some DB re-design to make it possible to JOIN instead of passing in long lists of data. On 2/6/07, Doug Brown <[EMAIL PROTECTED]> wrote: > > Well, this is the issue according to Microsoft. > > http://support.microsoft.com/kb/288095 > > Doug B. > ----- Original Message ----- > From: "Alan Rother" <[EMAIL PROTECTED]> > To: "CF-Talk" <cf-talk@houseoffusion.com> > Sent: Tuesday, February 06, 2007 5:03 PM > Subject: Re: Help with query please. > > > > Hey Doug, > > > > Not sure what is exactly happening, but what I would recommend is first, > > capture the output SQL from your CF. > > > > To do this, take all the SQL and put it into a CFSAVECONTENT > > > > Then dump that out and try using it in SQL Query Analyzer. It should > help > > narrow down where the issue is. > > -- > > Alan Rother > > Adobe Certified Advanced ColdFusion MX 7 Developer > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268920 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
