>> How big are they? most of these are only about 100-200kb. some with only 20-30 records (all tables total)
>> Do they need to be compacted? I'll try it but as I said before, we're getting timeouts even on the cfide/administrator page. and why would it work one minute and not the next and then come good? I've noticed something strange. Using the performance monitor on all 3 of our webservers produces a 97% "spike" in CPU resources. It looks like a heartbeat - every 10 sec or so. The biggest spike is on the problem machine (the others are lower). We've worked it back to JRun. any idea what it is? thanx barry.b -----Original Message----- From: Geoff Bowers [mailto:[EMAIL PROTECTED] Sent: Tuesday, 28 October 2003 5:03 PM To: CFAussie Mailing List Subject: [cfaussie] Re: CF webserver slows down - sometimes... Barry, These are MS Access databases? How big are they? Do they need to be compacted? -- geoff http://blog.daemon.com.au/ Beattie, Barry wrote: > 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!!! --- 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/
