to support Brian's idea, I've just verified all the datasources (in the CF admin) and half of them errored. after manually verifying/re-submitting a couple of them (they were OK) all datasources reported OK. go figure...
also when trying to use a DreamewaverMX recordset - it couldn't display all the fields, saying that a server timeout had occured and that the dsn wasn't set-up on the testing server (it was). but checking the query from DW (click on the recordset and the rs/sql config window opens) it worked fine and the error went away. any idea what these mean? the thick plottens! cheers barry.b -----Original Message----- From: Beattie, Barry Sent: Tuesday, 28 October 2003 11:01 AM To: CFAussie Mailing List Subject: [cfaussie] RE: CF webserver slows down - sometimes... >> if its a database / JDBC connector problem agreed - my thoughts too. I've been trying other pages that don't use db's and it hasn't spac'd out yet. but I've had it failing just bring up the CF admin datasources page which (correct me if I'm wrong) uses xml config files, not a db "Warning","jrpp-63","10/23/03","11:52:40",,"Thread: jrpp-63, processing template: D:\IISroot\Wwwroot\CFIDE\administrator\datasources\index.cfm, completed in 716 seconds, exceeding the 20 second warning limit" "Warning","jrpp-59","10/23/03","11:52:41",,"Thread: jrpp-59, processing template: D:\IISroot\Wwwroot\CFIDE\administrator\datasources\index.cfm, completed in 598 seconds, exceeding the 20 second warning limit" "Warning","jrpp-62","10/23/03","11:52:44",,"Thread: jrpp-62, processing template: D:\IISroot\Wwwroot\CFIDE\administrator\datasources\msaccess.cfm, completed in 916 seconds, exceeding the 20 second warning limit" "Warning","jrpp-73","10/23/03","12:28:41",,"Thread: jrpp-73, processing template: D:\IISroot\Wwwroot\CFIDE\administrator\datasources\msaccess.cfm, completed in 854 seconds, exceeding the 20 second warning limit" "Warning","jrpp-75","10/23/03","12:31:01",,"Thread: jrpp-75, processing template: D:\IISroot\Wwwroot\CFIDE\administrator\datasources\index.cfm, completed in 40 seconds, exceeding the 20 second warning limit" "Warning","jrpp-73","10/23/03","12:42:35",,"Thread: jrpp-73, processing template: D:\IISroot\Wwwroot\CFIDE\administrator\datasources\index.cfm, completed in 834 seconds, exceeding the 20 second warning limit" still on the hunt cheers barry.b -----Original Message----- From: Knott, Brian Sent: Tuesday, 28 October 2003 10:25 AM To: CFAussie Mailing List Subject: [cfaussie] RE: CF webserver slows down - sometimes... What about CF pages that don't access a database. This type of page will tell you if its a database / JDBC connector problem Brian -----Original Message----- From: Beattie, Barry Sent: Tuesday, 28 October 2003 10:22 AM To: CFAussie Mailing List Subject: [cfaussie] CF webserver slows down - sometimes... Hi all I'm asking for any advice on trying to get to the bottom of this. It's driving me nuts! we're getting stupid timeout errors that appear one minute/dissapear the next. I just checked it again and a page was taking over 5min to load but leave it for a minute and come back and it works blindingly fast. It's not IIS, I'm watching the taskmanager and all is fine (not working hard at all) and the asp pages aren't suffering this. so if anyone has any suggestions of what to specifically look for or try I'd appreciate it. thanx barry.b here's what I've found so far: calling pages: *.html/txt pages are fast *.cfm pages that have no cf code in them are fast *.cfm pages that access a db runs like a dog (with fleas) or times out -SOMETIMES!!! also, when using DW in design mode it's taking forever (plus with timeouts) for DWMX to call the CF server for the datasource schema's to be returned (using RDS over the LAN) so I'm thinking that the only connection between these 2 things are the databases and/or drivers and/or connections - almost all MSAccess db's and in most cases identical db's each with their own DSN. The code is good: 60% of the time it works fine (no errors, is fast, etc). But without warning everything slows down. here's something out of the logs "Warning","jrpp-122","10/28/03","09:23:46",,"Thread: jrpp-122, processing template: D:\IISroot\Wwwroot\bb\coffeesite\search.cfm, completed in 466 seconds, exceeding the 20 second warning limit" "Warning","jrpp-123","10/28/03","09:33:45",,"Thread: jrpp-123, processing template: D:\IISroot\Wwwroot\bb\coffeesite\search.cfm, completed in 758 seconds, exceeding the 20 second warning limit" "Warning","jrpp-124","10/28/03","09:37:36",,"Thread: jrpp-124, processing template: D:\IISroot\Wwwroot\bb\coffeesite\cartview.cfm, completed in 974 seconds, exceeding the 20 second warning limit" "Warning","jrpp-126","10/28/03","09:37:36",,"Thread: jrpp-126, processing template: D:\IISroot\Wwwroot\bb\coffeesite\search.cfm, completed in 725 seconds, exceeding the 20 second warning limit" "Warning","jrpp-122","10/28/03","09:37:36",,"Thread: jrpp-122, processing template: D:\IISroot\Wwwroot\bb\coffeesite\search.cfm, completed in 792 seconds, exceeding the 20 second warning limit" "Warning","jrpp-125","10/28/03","09:37:36",,"Thread: jrpp-125, processing template: D:\IISroot\Wwwroot\bb\coffeesite\cartview.cfm, completed in 805 seconds, exceeding the 20 second warning limit" --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/ --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/ --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/ --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/
