Re: TPC-A and -B Benchmarks

>From: uunet!shl.com!mrichardso >Subject: Re: TPC-A and -B Benchmarks >Date: Tue, 06 Jul 93 21:11:00 PDT >X-Informix-List-Id: <list.2468> >I believe cursor stability implies the maintenance of cursor positioning >across commits and/or rollbacks. Note that in some cases this could violate >ANSI standards. Oracle supports the ANSI mode and (I think) a more complete >implementation of cursor stability. Note that I said "I believe" at the >start of this paragraph and the relevant information is book knowledge, not >practical experience. No, cursor stability does not imply anything about cross-transaction behaviour. Cursor stability means that the row of data which is current for a cursor will not change while it is the current row. Once the cursor has moved onto another row, the row may be changed by other people or programs, but while it is the current row, it cannot be changed. This applies for both cursors FOR UPDATE and ordinary cursors (in Informix, at any rate). Informix supports cursors WITH HOLD to maintain cursor positioning across transaction boundaries. Yours, Jonathan Leffler (johnl@obelix.informix.com) #include <disclaimer.h>