RE: Locks - Significant Overhead?

Posted in 2000

William Rice — Fri, 24 Mar 2000 10:08:01 -0500 — source: Informix-list mailing list archive (1991-1998)

Sounds like a problem waiting to happen. Running out of locks can cause odd things to happen to your software. 1. If they didnt think of the fact that they might run out of locks, how thorough were they in handling errors like running out of locks. 2. How much testing is done with a low number of locks? 3. I have seen the engine start behaving funny after running out of locks (Though this was quite a few versions back... 7.10). 4. Deadlocks might be more likely. Seems like it has the potential to cause to much pain not to fix. But then again, I don't like pain. As far as the impact goes. I dont know what the solutions you are looking at, or the usage of the system, But holding a lock for 30 minutes seems like potential for causing problems. Will >===== Original Message From "Henderson, Scott" <SHenderson@purolator.com> ===== >Folks, > >OS:HPUX 11.0 >ODS:7.30 FC7 >Memory: Tons > >I'm of the opinion that increasing the locks to compensate for poor >query/program design is not the best approach. Keep the value low and have >the programs work within these constraints. However, I've been asked to >determine the impact by increasing our current value of 400,000 to >1,000,000. The manual tells me 44 bytes per lock. Not a big deal in terms >of memory. Other than an increased memory segment, what else should I be >aware of. >One program running for approximately 30 minutes utilizes 240,000 locks. >This program may be executed by several people at one time. I have >communicated that they should re-think there design, they are. However, >they are in the 11th hour. > >Thanks in advance, > >Scott H. ------------------------------------------------------------ This e-mail has been sent to you courtesy of OperaMail, as a free service from Opera Software, makers of the award-winning Web Browser, Opera. Visit us at http://www.opera.com/ or our portal at: http://www.myopera.com/ Your free e-mail account is waiting at: http://www.operamail.com/ ------------------------------------------------------------