Re: Need advice (Informix 5.02)
We encountered a similar problem with a Bluebird imaging system. The more images that got put into the system, the slower the inserts. Trace every sql statement that gets executed during an insert. Echo the system time in between each statement. Maybe you can track down which (if any) sql statement is slow (make sure statistics have been updated). We discovered an integrity constraint was slowing a delete (the constraint was on a column with just one value). Removing the constraint changed index time from 2 minutes per image to 6 seconds per image... Good luck Mr. Phelps :) - JFV Peter Whitman wrote: > > Just a general query, we have been having some problems with our > database/system/network and I want to know if anyone has seen or knows of > problems like the ones we are having.... The database is used to store > scanned images (10-20k each image and up to 40-50 images are scanned and > then batched to the database to be updated) > > The hardware platform is a ALR 90Mhz Pentium system with 128M of memory, DPT > disk controllers, 4 drives (striped). OS is Interactive Unix 3.01 NIC card > is a 3Com 3C509b. Workstation front-end is a Powerbuilder application using > ISTAR/INET client. > > Intermittantly users accessing/updating the database experience 6-8 minute > response times when a transaction is updated (transmit screen and a new > screen is displayed) or the application on the workstation hangs. Sometimes > the Unix system itself runs very slow, when you look at sar it shows I/O > activity going as high as 92% or user processes at 90%. Network streams > resources show no failures. (Workstations are a mix of Win95 and Win3.1) > > Now please don't flame me.... I am just the poor network grunt who was > brought in on these problems, the network is being blamed on all the > problems.. What I'm after is...has anyone else seen anything like this?? > any thoughts/ideas/troubleshooting tips would be greatly appreciated! > > Thanx for any help/ideas...... > > whitman@aottsd.uscourts.gov