Re: LOCKS urgent
--Boundary_(ID_SflCz6Qm9vMb3qowWKH5Ug) Content-type: text/plain; charset=us-ascii Content-disposition: inline Content-transfer-encoding: 7BIT George AFAIK, Informix does not do lock escalation like Sybase does. Sybase does this when it figures it is locking a lot of rows for a given query, so it escalates the lock level to page level to keep the number of locks consumed to a reasonable level. HTH Sujit George Ayou <gayou@SSG.PETsMART.com> on 03/03/2000 02:46:10 PM To: informix-list@iiug.org cc: Subject: LOCKS urgent does Informix change the level of table locks? and why. for example, from row lock to page lock or table lock --Boundary_(ID_SflCz6Qm9vMb3qowWKH5Ug) Content-type: text/html; name=att1.htm Content-description: Internet HTML Content-disposition: attachment; filename=att1.htm Content-transfer-encoding: 7BIT <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1"> <META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2448.0"> <TITLE>LOCKS urgent </TITLE> </HEAD> <BODY> <BR> <P><FONT SIZE=2 FACE="Arial">does Informix change the level of table locks? and why. </FONT> </P> <P><FONT SIZE=2 FACE="Arial">for example, from row lock to page lock or table lock </FONT> </P> </BODY> </HTML> --Boundary_(ID_SflCz6Qm9vMb3qowWKH5Ug)--