Re: Row and page locking

Vijay R. Anisetti wrote: > > Bill Glidden wrote: > > > > davin_harvey@dsti.co.uk wrote: > > : Hi everybody, > > : =20 > > : Does anyone know if there is a difference in the time it > takes to=20 > > : place a row lock rather than a page lock? > > : =20 > > : Ta > > : Davin > > > > no difference that I can think of. > > Though there might be a difference between the two, it will be > negligible > should play no importance in the decision making. > > My theory is that a Page lock is quicker as there is a defined no. of > bytes > to lock all the time. Whereas for a row lock it requires to know the > no. > of > bytes to lock and task of calculating the rowsize is compounded if it > has any > variable columns in size (varchar). I think you're confusing row lock with byte lock. The latter does need to know the number of characters that changed. Cheers, -- Mark. +----------------------------------------------------------+-----------+ |Mark D. Stock - Informix SA http://www.informix.com |//////// /| |mailto:mdstock@informix.com FAQ http://www.iiug.org |///// / //| | +-----------------------------------+//// / ///| | Tel: +27 11 807 0313 |If it's slow, the users complain. |/// / ////| | Fax: +27 11 807 2594 |If it's fast, the users keep quiet.|// / /////| |Cell: +27 83 250 2325 |Therefore, "No news: travels fast"!|/ ////////| +----------------------+-----------------------------------+-----------+