You might try adjusting the long text buffers in CF Admin or blockfactors on that query to more closely control the flow of data. Just a guess...
-----Original Message----- From: Cantrell, Adam [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 22, 2002 11:37 AM To: CF-Talk Subject: RE: sql 7 MDAC In the last few minutes, I was able to actually narrow the issue down to the exact column, instead of the query. The exact query below works flawlessly when I omit the ASSIGNMENTS.txt_description field from the query. The data type in SQLserver is ntext. As soon as I add that field to the query though, the CPU goes to poop again and won't come down until I restart CF. Please don't tell me I'm going to have to store all of my text columns in individual files. Has anyone else had issues with text or ntext data types? The max size of any of the values is nowhere near 1k in that column, so it shouldn't be a bandwidth/memory issue. The server is pretty hefty on the resources too. Adam. -----Original Message----- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 22, 2002 3:13 PM To: CF-Talk Subject: RE: sql 7 MDAC Adam, How big is the query. I noticed it's from a view - are other queries from views giving you any problems? mark -----Original Message----- From: Cantrell, Adam [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 22, 2002 11:03 AM To: CF-Talk 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. ______________________________________________________________________ Why Share? Dedicated Win 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=coldfusionc 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