Re: Informix vs. Sybase vs. Oracle vs. (gasp) MS SQL Server

>>>>> "Scott" == Scott C Gray <ickyspam_gray@voicenet.com> writes: Scott> >> Anyway, I think the answer lies with the TPC-C. I think >> that they prove that row-level vs page-level locking is not >> an issue. The -C's are a finely tuned OLTP application. Scott> Scott> I think we may have drifted into a small tangent here...I think Scott> the real question that many developers are interested in (at least Scott> consciencious (sp?) ones) is whether or not the page level Scott> locking (PLL) concurrency solutions are a hinderance on performance Scott> of the application. I agree that the crux of the matter is whether row-level vs page-level is really an issue. That's why I stated the -C's. The reason is because (even with its faults) the -C's allow us to take a normalized 'application' and see how well the RDBMS engine works. My point is that what we see is that all the RDBMS engines are doing fine. Even if we take the current high number for Informix: ~24k tpmC you are doing *way* more tx's than you'll ever do on your app. Comparing Sybase's current high of ~34k it is still way more than you'll ever do... (for completeness, I believe that Oracle's is around 55k ... I'm too lazy to check...) Anyway, back to my point, since all the big RDBMS do well in the -C's, then there really is little differences in them... what it boils down to is what the CIO decided (ten years ago) for your shop. The rest is hype. -- Pablo Sanchez | Ph # (650) 933.3812 Fax # (650) 933.2821 pablo@sgi.com | Pg # (800) 930.5635 -or- pablo_p@pager.sgi.com ------------------------------------------------------------------------------- I am accountable for my actions. http://reality.sgi.com/pablo [ /Sybase_FAQ ]