Re: Informix vs. Sybase vs. Oracle vs. (gasp) MS SQL Server
From: Anthony Mandic <no_sp.am_at_agd.nsw.gov.au>
Date: 1997/12/02
Message-ID: <34838EE7.50DA_at_agd.nsw.gov.au>#1/1
Date: 1997/12/02
Message-ID: <34838EE7.50DA_at_agd.nsw.gov.au>#1/1
Gary L. Burnore wrote:
> Question: If row level locking isn't important, why does sybase tell you how
> to sorta-do row level locking by setting the size of a row to the size of a
> page?
Its called buffering or padding a row. And its not to the size of a page. You just make it large enough so that another row can be placed on that page. Its the usual answer to users who think they need RLL in a PLL environment. I don't think this is what Sybase says. Its more than likely what others would say in the Sybase newsgroup. There are better solutions.
-am Received on Tue Dec 02 1997 - 00:00:00 CET