Thanks for the heads up Scott. Yes, I am aware that the IN clause can wreak havoc when it gets large. That's partially why I prefaced my message by saying, I would have done things differently. But they don't want to pay me for a "good" fix or a rewrite. They just wanted a quick Band-Aid. :-)
-Novak ----- Original Message ----- From: "Scott Weikert" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, October 09, 2002 2:06 PM Subject: Re: SOT: Limit to SQL IN statement? > I've found that having huge IN lists can reaaaaaaaaally drag the query > performance dowwwwwnnnn. I haven't found a hard limit... > > At 01:04 PM 10/9/2002 -0700, you wrote: > >My concern is... what if there are 1000, 5000, or even 10000 records that > >need updating? Is there a limit as to how many elements can be in the list? > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
