Re: Informix beats Oracle

Posted in 2007

DA Morgan — Wed, 20 Jun 2007 06:19:43 -0700 — source: Usenet: comp.databases.informix

Data Cruncher wrote: > "Data Cruncher" <dcruncher4@aim.com> wrote in message > news:4MKdnTxfuekqc-XbnZ2dnUVZ_rKvnZ2d@comcast.com... >> When I said SS/Informix offers other choice, it means >> that the developers has a choice to bypass CPU intensive >> versioning mechanism. Does Oracle offer a way to bypass >> check for block versioning and then fetch from UNDO segment. >> AFAIK - no. The only other choice they have is actually >> worse from concurrency point of view, like SERIALIZABLE. > > or it bypasses SCN check for read-only tablespaces, which > works for only read-only tables. The concept docs can be found at: http://tahiti.oracle.com This group's Oracle knowledge is current to version 8i. <g> -- Daniel A. Morgan University of Washington damorgan@x.washington.edu (replace x with u to respond)

↪ replying to DA Morgan

David Buchholz — Wed, 20 Jun 2007 07:07:28 -0700 — source: Usenet: comp.databases.informix

-----Original Message----- From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org] On Behalf Of DA Morgan Sent: Wednesday, June 20, 2007 6:20 AM To: informix-list@iiug.org Subject: Re: Informix beats Oracle Data Cruncher wrote: > "Data Cruncher" <dcruncher4@aim.com> wrote in message > news:4MKdnTxfuekqc-XbnZ2dnUVZ_rKvnZ2d@comcast.com... >> When I said SS/Informix offers other choice, it means >> that the developers has a choice to bypass CPU intensive >> versioning mechanism. Does Oracle offer a way to bypass >> check for block versioning and then fetch from UNDO segment. >> AFAIK - no. The only other choice they have is actually >> worse from concurrency point of view, like SERIALIZABLE. > > or it bypasses SCN check for read-only tablespaces, which > works for only read-only tables. DAMorgan "wrote" : > The concept docs can be found at: > http://tahiti.oracle.com > This group's Oracle knowledge is current to version 8i. <g> Yeah, Daniel, and your Informix knowledge seems current to version 5.1. Big <g> The only difference is that we don't troll the Oracle newsgroups. -Dave

↪ replying to David Buchholz

DA Morgan — Wed, 20 Jun 2007 12:44:48 -0700 — source: Usenet: comp.databases.informix

David Buchholz wrote: > The only difference is that we don't troll the Oracle newsgroups. You may not. Others here do. As I acknowleged to Marco ... my error and I knew better. I am preparing for a major conference (http://www.psoug.org/oraday/schedule.html) next week and I'm more than a bit tired. So my apology for pressing the Send button without the proof-read. -- Daniel A. Morgan University of Washington damorgan@x.washington.edu (replace x with u to respond)