Re: Which is better Sybase/Oracle??

DA Morgan wrote:

I can't publish numbers (darned NDA's) but I can tell you there comes
a point, not hard to achieve, where locking and lock escalation become
a show-stopping burden to the system. Once that is achieved it it is
like watching a system that begins swapping pages to disk: Painful.

Well, I'm sure there are independent benchmarks to which
I'm sure your NDA wouldn't apply.

Just digging on Sybase's web site for a few seconds, I
came up with this:

http://www.sybase.com/detail?id=1041449

Highlights:

"Sybase, Inc. [. . .] and IBM today announced that IBM
System p5 520 and Sybase Adaptive Server Enterprise® (ASE)
for Linux set a new transaction processing performance
record for 2-core systems by delivering 81,439 transactions
per minute (tpmC) on the leading TPC-C benchmark. [. . .]
This new record beats the previous 2-core HP/Itanium2 and
Oracle 10g performance record for Linux by 58 percent."

Not that this result directly addresses your point about
larger systems -- it's just what I found after a few
seconds' searching. I'm sure the independent benchmarks
are out there for larger systems.

I will say that the lock escallation nightmare you describe
above has not been my experience.


Larry Coon
University of California
.