Even though my workplace and reduced costs by migrating from Sybase on Solaris to Sybase on redhat. We are now in a move from Sybase to MySQL to further reduce the license costs of the applications. This has brought to forefront one of the reasons to use Sybase. Triggers and stored procedures. And while MySQL [...]
Archive for the ‘SQL’ Category
MySQL Triggers weak support for referential integrity
Posted in RDBMS, SQL, Sybase, tagged Functions, InnoDB, MySQL, Procedure, Sybase, Triggers on February 21, 2009 | Leave a Comment »
Row level Locking
Posted in Oracle DBMS, RDBMS, SQL, Sybase on August 27, 2006 | 3 Comments »
In the Sybase vs Oracle discussion there is always one issue that Oracle used to win. Row level locking. In the early days of Sybase, page level locking was the lowest level of granularity that locks attained. Much of this was due to a conscious choice of increasing the performance of the transaction, rather than [...]
Sybase vs Oracle
Posted in IT Issues, Oracle DBMS, Personal, SQL, Solaris, Sybase on August 23, 2006 | 6 Comments »
I’ve seen some discussion around the internet about the age old argument about which is best Sybase or Oracle. I have been reading Mr. Talebzedah article on Sybase vs. Oracle: 10 reasons to use Sybase on Linux and I would agree with many of his statements. Having installed and used both over the years, [...]
