Re: Informix beats Oracle

Data Cruncher wrote: > "DA Morgan" <damorgan@psoug.org> wrote in message > news:1182298306.525484@bubbleator.drizzle.com... >> Fernando Nunes wrote: >> >>> In practice, I think this has the same results. Using this, you won't >>> block when trying to read a row that has a lock (not a shared one, but an >>> insert/update/delete lock). You will get whatever was there (or >>> wasn't...) before the operation holding the lock. >> This would be a major step forward for Informix if this is what it >> appears to be. >> >> Can anyone confirm the following statement is true? >> >> "Reads don't block writes and writes don't block reads and only >> committed rows are visible." >> >> And yes SQL Server finally got a measure of this with 2005 whereas >> Oracle has had it for decades. > > And unlike Oracle, both SS and Informix offer other isolation levels > also, which means, that developers can use them appropriately. And unlike you some people read the docs. Oracle offers other isolation levels too. http://download-west.oracle.com/docs/cd/B19306_01/server.102/b14220/consist.htm#CNCPT621 If you are going to bash something at least choose a valid point on which to bash. One thing I find fascinating about some in this crowd is the willingness to close their eyes and throw punches. Those of us who actually know Oracle throw them too. But ours are on target. -- Daniel A. Morgan Puget Sound Oracle Users Group www.psoug.org

DA Maroon wrote: >If you are going to bash something at least choose a valid point on >which to bash. One thing I find fascinating about some in this crowd >is the willingness to close their eyes and throw punches. > >Those of us who actually know Oracle throw them too. But ours are on >target. >-- >Daniel A. Morgan >Puget Sound Oracle Users Group >www.psoug.org Why? That's never stopped you. With respect to Oracle, I can't stand how you have to consider the database that you want to attach to as the "user". Very bizzare. And don't get me started on Quad Tree indexing. Oh and that nasty bug with their r-tree spatial indexing that is a major performance problem in 9 that supposedly got fixed in 10. Then there are their memory leaks in their JDBC drivers... Yes Daniel, I grok software development against Oracle. _________________________________________________________________ Don't miss your chance to WIN $10,000 and other great prizes from Microsoft Office Live http://clk.atdmt.com/MRT/go/aub0540003042mrt/direct/01/