How to implement Updatable CURSOR
From: leon <captain_cnus_at_yahoo.com>
Date: 17 Mar 2002 18:52:34 -0800
Message-ID: <29e4c617.0203171852.3e8cd21d_at_posting.google.com>
For Read-only cursor, maybe we can make a copy of results, but how to for updatable one. If with the same way, the consistency between copy cursor and real DB is a problem. If we only keep the location in DB, in order to prevent others modify those rows in result set, we must lock all these rows, which will influence the performance heavily.
Date: 17 Mar 2002 18:52:34 -0800
Message-ID: <29e4c617.0203171852.3e8cd21d_at_posting.google.com>
For Read-only cursor, maybe we can make a copy of results, but how to for updatable one. If with the same way, the consistency between copy cursor and real DB is a problem. If we only keep the location in DB, in order to prevent others modify those rows in result set, we must lock all these rows, which will influence the performance heavily.
Is anyone able to give some advice? Received on Mon Mar 18 2002 - 03:52:34 CET