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@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++++/** -----------------------------------------------------------