Re: Informix vs. Sybase vs. SQL Server vs. Oracle

Liu jun wrote: > > Laura P. Grahame wrote: > > > > I am looking for guidance on selecting a database backend which can handle > > the multiple simultaneous row updates without slowing. > > That sounds like you want to select a DBMS backend with high performance > of Currency Control. > > Oracle's concurrency control mechanism is better than Informix. > > Have you test your application with Informix/Oracle server? > > multiple simultaneous row updates would run faster if you use index. > This will reduce collision. > > LiuJun No, I cannot conform to this statement. Oracle's only advantage is with concurrent read and update, since it does not need a read lock. But if you use dirty read isolation, you don't have read locks in Informix either. Overall Performance on same hardware will allways be better with Informix. Andreas