If your table is that big, don't use MS-SQL. If he didn't like MS products, perhaps he would know a more concise term then "crapping out".
Searching in "chunks" of records will probably cost you MORE cpu time, not less. If there is no index on the fields in question, apply relevant indexes to make the select faster. If there are indexes, the "OR" statement may be preventing the usage of an index. Try using a UNION across 2 separate queries. Terry Fielder Network Engineer Great Gulf Homes / Ashton Woods Homes [EMAIL PROTECTED] > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On > Behalf Of A. Karl Zarudny > Sent: Wednesday, June 12, 2002 12:30 AM > To: [EMAIL PROTECTED] > Subject: [CFTALKTor] searching 65 million records with MSSQL > > > Hi everybody. > > Hopefully one of you can provide some insight to this one. I > recently met > someone who said they were having trouble with MSSQL > crapping-out (that's a > technical term) when querying a 65 million record db. Their > SQL statement > which they were apparently trying to run from Query Analyser, > was something > like.... > > select > acolumn, > bcolumn, > ccolumn > from > tablename > where > (acolumn = 'boo' AND bcolumn = 'yikes') OR > (bcolumn = 'haha' AND ccolumn = 'clown') > > > I'll try to get the exact query they were trying to execute. > However any > thoughts at this point? Is 65 million records more than MSSQL > can handle? > Any suggested workarounds?.... perhaps search in chunks of records as > opposed to all of them? > > Thanks, > Karl > > - > You are subscribed to the CFUGToronto CFTALK ListSRV. > This message has been posted by: "A. Karl Zarudny" > <[EMAIL PROTECTED]> > To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/ > Manager: Kevin Towes ([EMAIL PROTECTED]) http://www.CFUGToronto.org/ This System has been donated by Infopreneur, Inc. (http://www.infopreneur.net) - You are subscribed to the CFUGToronto CFTALK ListSRV. This message has been posted by: [EMAIL PROTECTED] To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/ Manager: Kevin Towes ([EMAIL PROTECTED]) http://www.CFUGToronto.org/ This System has been donated by Infopreneur, Inc. (http://www.infopreneur.net)
