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

On 8 Jan 98 at 16:46, 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. Er, no, not really. There are database design issues, hardware selection issues and concurrency issues. > Oracle's concurrency control mechanism is better than Informix. Better? I would say different. But I would certainly agree with: > Have you test your application with Informix/Oracle server? I'm not sure about: > multiple simultaneous row updates would run faster if you use index. > This will reduce collision. You obviously have to remember that your update might have update data and index, causing performance degradation. FWIW. -- Ciao, Billy Back at the gold-face in sunny Gauteng... Informix FAQ @ http://www.iiug.org/techinfo/faq/faq_top.html Drivel @ http://www.west.co.za/tasteless/