Re: Row and page locking

davin_harvey@dsti.co.uk wrote: > > Hi everybody, > > Does anyone know if there is a difference in the time it takes to > place a row lock rather than a page lock? No difference. It is just that if many rows on a page are to be locked in a typical transaction row level locking requires more resources and more time while providing greater concurrency for multiple users when few rows on a page are being locked by any one user. The trade-off is greater concurrency (row level) -vs- less resources (page level). Art S. Kagel