Re: Does Informix do Versioning Read-Only Transactions?

Graeme Sargent (graeme@pyramid.com) wrote: : D. Erway (derway@ndc.com) wrote: [ stuff deleted ] : : Sorry, I wasn't clear. The Oracle feature, (and Multi-versioning consistency : : control in general), allows a repeatable read snapshot of the whole database, : ^^^^^^^^^^^^^^ : Bullshine! : *NOBODY* configures their Rollback Segments (or rather the tablespace(s) : containing them) *that* large! Well that was a pretty *stoopid* comment, Graeme!!! Before you all flame me (although it's probably too late), I would like to point out that I do realise (when my brain is connected to my fingers) that Rollback Segment space is proportional to update activity and completely independent of whether or not you deceide to *read* the whole database. Unfortunately, I went home immediately after hitting the "post" button, and I was already on the motorway before I realised what an idiot I had been. I will try to engage brain before posting in future! Apologies to Don. Please direct flames to /dev/null. : -- : graeme : -- : Disclaimer: The author's opinions are his own, and not necessarily : those of Pyramid Technology Ltd. or Pyramid Technology Inc. : --------------------------------------------------------------------------- : -m------- Graeme Sargent Voice: +44 (0)252 373035 : ---mmm----- Senior Database Consultant Fax : +44 (0)252 373135 : -----mmmmm--- Pyramid Technology Ltd. Telex: Tell who??? : -------mmmmmmm- Farnborough, Hants GU14 7PL Email: graeme@pyra.co.uk : --------------------------------------------------------------------------- : We have the technology. The tricky bit is learning how to use it. -- graeme -- Disclaimer: The author's opinions are his own, and not necessarily those of Pyramid Technology Ltd. or Pyramid Technology Inc. --------------------------------------------------------------------------- -m------- Graeme Sargent Voice: +44 (0)252 373035 ---mmm----- Senior Database Consultant Fax : +44 (0)252 373135 -----mmmmm--- Pyramid Technology Ltd. Telex: Tell who??? -------mmmmmmm- Farnborough, Hants GU14 7PL Email: graeme@pyra.co.uk --------------------------------------------------------------------------- We have the technology. The tricky bit is learning how to use it.