Re: Sybase vs Oracle - which is better?

Hello,
 Page locking vs. row locking is really defined by the design philosophy. You know up front that applications will cause page contention problems. So, you design the database schema to deal with these issues. You would deal with this in the same manner you would deal with applications where you know there will contention for a particular row. You just do it at a page level. There isn't too much difference. One of the few time I've seen this problem at a page level, row locking would have caused the same problem. Multiple applications cause a hot spot on a table with a sequental key..all of then wanted to look at or update the last row ( highest sequence number ) and add the next row on the page..we solved the problem ( for the most part ) by creating a new clustered index so that the highest sequence number wasn't necessarily on the last page..

Robert

Philip Brown wrote:
>
> On Wed, 25 Nov 1998 11:10:14 -0500, iron_horse_at_compuserve.com wrote:
> >....
> >Row vs. Page locking granularity ... after 7 years with Sybase I have yet
> >to run into an application where page locking was an issue. If there have
> >been locking issues it has arisen from poor database and/or application/SQL
> >design. The granularity of the Sybase locks (at the page level) have never
> >been a problem. (My last Sybase environment was running 1500 concurrent
> >users against a 140GB OLTP database ... and the only lock problems were
> >poor application design!)
>
> I'm a complete database newbie, but I have a background in programming... so
> this seems to be not such a great example of "row locking isn't important".
> I would think that the larger your database, the less likely you are to need
> row locking. So it would be more interesting if you had 1500 users,
> and a 4 GB OLTP database, without needing row locking, I would think.
>
> comments?
>
> --
> [trim the no-bots from my address to reply to me by email!]
> --------------------------------------------------
> "initiating.. 'getting the hell out of here' maneouver" - Lennier, babylon5
  Received on Mon Dec 07 1998 - 00:00:00 CST