Re: Row and page locking

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). -- \\\\|// Vijay R. Anisetti |6 6| -------------------oooO--U--Oooo---------------------------- oooO Oooo ( ) ( ) Just hangin there ---------------\\( -- )/------------------------------------- \\) (/