Hi Paul >> It's (IMO) the JDBC-ODBC bridge, ie: the code that's connecting to Access...Ditch it. Get a decent database
Hmmm... I've got 3 problems with this 1) these same websites are working fine on the localhost:8500 dev servers (every machine has one). The sites are being moved from localhost:8500 to one machine for "hosting" 2) the students are used to using MSAccess. it can be carried around on a floppy. there are zero issues with versioning, attach/detatch the db, etc. anything else is way overkill (besides you're saying that it isn't MSAccess at fault but the supplied JDBC driver) 3) you're not saying that CF has problems on something that ASP/IIS found easy to do, are you? Surely not..... any ideas on what to do to get to the bottom of this? debugging ideas? things to look for/try? thanx barry.b -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, 28 October 2003 5:22 PM To: CFAussie Mailing List Subject: [cfaussie] Re: CF webserver slows down - sometimes... On Tue, Oct 28, 2003 at 05:11:18PM +1000, Beattie, Barry wrote: > >> 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? It's (IMO) the JDBC-ODBC bridge, ie: the code that's connecting to Access. It's evil. Ditch it. Get a decent database. We had the same sort of problems for ages, running a db via ODBC. The system would just seem to freeze for no apparent reason, inconsistently. Bit the bullet, moved to an external database accessible via JDBC drivers (PostgreSQL) and we haven't had a blip since. Paul Haddon Technical Services Manager Formstar Print Technologies --- 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] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
