MVCC: Dispelling Some Oracle FUD/Understanding the Cost
Several times over the past few months, I have been asked about “Sybase scalability” vis-à-vis using locking vs. versioning ala Oracle. It appears that lacking any real innovation over the past years, when Sybase didn’t die in 2002 after Larry Ellison’s premature pronouncement of our death, Oracle sales reps have dug out their tired old argument about “readers and writers” and that versioning in somehow superior to locking for concurrency control – betting that the average Sybase DBA just doesn’t know how to put them in their place……and rightfully so as Sybase doesn’t give its customers the facts to fight this FUD. I even had to come in (much too late) on a “customer benchmark” in which Oracle 11g supposedly trounced ASE 15 due to MVCC vs. locking – when no one even bothered to capture the wait statistics to see if locking was even a consideration. The reality was that some poor JDBC defaults and some lack of ingenuity were likely the real culprits – and not a “lack of scalability due to locking”.
So let’s get right down to it. (more…)


Rob Verschoor is a Technical Director and Data Management Evangelist at Sybase, located in EMEA. Rob's focus is on Adaptive Server Enterprise, ASE Cluster Edition, Replication Server, and Sybase IQ; he has a true passion for query performance and stressing ASE to its limits.