Re: Need Locking Edification
Cosmo Lee (*NO-SPAM*cosmo@echonyc.com) wrote:
: We're having a problem that when we are running deletes from a table,
: users are locked out from completing Selects, and Inserts fail. We
: can't quite figure out why this happens . . .
The selects can probably be helped by first doing a:
set isolation to dirty read;
SELECT blah, blah blah.....
There's not much you can do to help with the inserts, using the delete
statement you quoted. It'll probably be a lot faster if there is an index
on the call-date....keep it locked for less time anyway and less possibility
of contention.
You might want to write an esql/c program that creates a cursor with hold
and then deletes rows one (or several hundred) at a time. If you have my
Survival Guide, there's a sample of this (look up "flutter locks").
Joe
--
---------------------------------------------------------------------------
Joe Lumbley(jlumbley@netcom.com) author of: "INFORMIX DBA Survival Guide"
Slaving away on "INFORMIX DEBUGGERS Survival Guide", available early 1998
from Prentice Hall/Informix Press. If you have debugging tips, tools, or
ideas to share, please send me some e-mail.
---------------------------------------------------------------------------