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/
