RE: dirty read isolation in views

Posted in 2008

Ian Michael Gumby — Fri, 19 Dec 2008 19:24:51 +0000 — source: Usenet: comp.databases.informix

> Date: Fri, 19 Dec 2008 17:24:25 +0000 > From: obnoxio@serendipita.com > CC: informix-list@iiug.org > Subject: Re: dirty read isolation in views > [SNIP] > > What about OfficeConnect? > I believe you'd still run in to the same problem. However... why can't the user just issue a SET ISOLATION LEVEL command prior to the queries? I believe that the SET command is valid for the session only. My solutions were based on trying to get the data isolated in to a separate table so that they could perform their queries or do any sort of analytics without impacting their OLTP environment. (Ok, using a trigger to write to a separate table would have a minimal performance impact.) The OP hasn't said how important 'real time' data is for them. So if all we have to go on is that they're using a spreadsheet and they want to pull data from IDS, what's the best way to do it such that it doesn't impact their existing OLTP app(s). -G _________________________________________________________________ It’s the same Hotmail®. If by “same” you mean up to 70% faster. http://windowslive.com/online/hotmail?ocid=TXT_TAGLM_WL_hotmail_acq_broad1_122008