Re: Record Locking and Performance Concerns

In article <2kvn5i$26j@rmg01.prod.aol.net> afajimw@aol.com (AFA JimW) writes: >A prospective client is concerned that our proposed Informix-based solution >won't provide the necessary level of performance. This is a real-time system, >with perhaps 10 users. I need to get some performance comparisons of Informix >with other Unix-based RDBMSs in order to defend our choice of Informix (or >convince us to switch to Oracle or Sybase). > >Also, this client is concerned about "serious record locking problems" with >Informix. Can anyone shed light on this problem? What are its symptoms and >causes? What is Informix doing to correct the problem? > >Any insight is appreciated. Please feel free to e-mail responses if you'd >rather not post publicly. We support >500 concurrent users with >1sec response time using a client-server based transaction system. We get a lockup about once or twice a month for 5-10 minutes, caused by Data Mangagement people globally modifying inventory. ----------------------------------------------------------------- Jim Burks jburks@promus.com The Promus Companies Memphis, Tennessee, USA