If it helps...the MDAC bug that would cause the 100% CPU spike didn't matter when it came to query size or complexity. It would just do it for some queries and not others (we're talkin SELECT * FROM TABLE when there's 10 records). I never found any kind of pattern to it. I don't remeber ever hearing of it happening with SQL Server, just Access.
Bryan Stevenson VP & Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] --------------------------------------------------------- Macromedia Associate Partner www.macromedia.com ----- Original Message ----- From: "Cantrell, Adam" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, January 22, 2002 11:03 AM Subject: RE: sql 7 MDAC > due to forces beyond my control, we are stuck with ODBC. > > I've updated the MDAC to 2.6 SP1 and it updated the SQLserver ODBC driver, > but the same query still pegs the CF server to 100% CPU. I have pasted the > query into it's own CF template, and I'm calling it directly - there is > nothing in application.cfm. This is crazy, all this time I've heard people > with this dreaded issue, never thinking it would happen to one of my boxes, > and now it has. The weird thing is, I've got larger, much more complex > queries that are running just fine. I've done a lot of snooping around the > "macromedia forums", and found a few tips regarding mail spool files, and > other things - nothing has helped. > > I doubt anyone has the definitive answer, otherwise there wouldn't be so > many posts in the forum about this and it would have been fixed a few > releases back when it was first discovered. I am just at my last resorts > here and was hoping that SOMEBODY can offer a fix. > > > > > -----Original Message----- > From: Steve Oliver [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, January 22, 2002 11:40 AM > To: CF-Talk > Subject: RE: sql 7 MDAC > > > Have you tried using OLE DB or a Dynamic query with a connection string? > > ______________________ > steve oliver > cresco technologies, inc. > http://www.crescotech.com > > > -----Original Message----- > From: Cantrell, Adam [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, January 22, 2002 12:27 PM > To: CF-Talk > Subject: sql 7 MDAC > > > Hi there, has anyone researched which ODBC driver is most stable with CF > 5 and MSSQL 7? We are currently running the 3.70.09.61 SQLserver driver > and this query will crash CF to 100% CPU every time I run it: > > <CFQUERY datasource="#request.mainDSN#" Name="ViewAssignment"> > SELECT > ASSIGNMENTS.num_contentid AS contentid, > ASSIGNMENTS.dat_start AS dat_start, > ASSIGNMENTS.dat_due AS dat_due, > ASSIGNMENTS.bit_complete AS bit_complete, > ASSIGNMENTS.txt_description AS txt_description, > CONTENT.contenttitle AS title, > CONTENT.editable AS editable > FROM ASSIGNMENTS, CONTENT > WHERE > ASSIGNMENTS.num_contentid = CONTENT.contentid AND > ASSIGNMENTS.num_contentid = #attributes.contentid# > ORDER BY ASSIGNMENTS.dat_due > </CFQUERY> > > > > I'm not exactly sure which MDAC is installed. Is it advisable to update > to the most recent MDAC even though we're not running SQL 2000 yet? I > noticed on this site, that the MDAC is up to 2.7 - > http://microsoft.com/data/ > > Thanks for any of your help. > > > > > ______________________________________________________________________ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists