Re: Informix, Sybase, Oracle or MS SQL server

> : Sybase:
> : Liked dealing with them but it seems that they have some serious
> : problems--no row-level locking, no two-phase commit. I like their
 

> There's another thread in here kicking around row level vs page level locking.
> It pops up periodically. I have not found page level locking to be a problem.
> It minimizes the work the server has to do which is good for performance.
> 2K is usually just a few rows (usually), and your database design will
> frequently handle it (carefully choose what you create your clustered indexes
> on, if you need them, to avoid insert hot spots, bundle transactions (begin
> and end transaction) so that updates don't hold locks for extended amounts
> of time -- that kind of thing).

I reckon it's a hell of a lot easier to say "ALTER TABLE x LOCK MODE ROW"!! :-) No, but seriously, I've found row level locking to be an absolute godsend on high concurrency sites. It's not easy to sensibly design a database with 2K rows... :-)

Just an opinion, but based on experience...

--

Cheers,

Billy

-----------------------------------------------------------
e-ddress: billy.wheeler_at_pixie.co.za
    Work: +27 11 803 2151
     Fax: +27 11 803 2189
    Cell: +27 83 250 2324
GCM/CS d++(--) h--- s+:++ !g p?+ au++ a? w+ v++/* C+++ 3 k-
UCLAVH++++ p+++ L++ E-- N++ W--- M" V-- -po+ y+ t+ !5 j++ 
R+ G? tv+ b+++ D+ B-- e+ u** h----(++) f+ r+++ !n z++++/**
-----------------------------------------------------------