Oracle or Sybase which is better ? why ?

[parbhani]

Hi Guys,

We have a MS-Access based application. Its growing a lot and we are slowly thinking, what if we migrate it to some bigger RDBMS ?

So, as usual there is a question. Should we go to Oracle or Sybase ? why ? why not ?

Your opinions and experiances are most valuable.

Regards

 

[Michael42]

FYI,

Some months ago I was commissioned to create a lab to compare: Sybase12, MySQL and Oracle 9i.

Sybase came in last in all tests. These tests were done on Sun Solaris 240 server using 20-60 gig of data by various developers.

I know my description of "tests" is generic but basically involved Inserts,Updates,Delete, Transactions and complex SQL etc. etc. etc. Oralce was found to be fastest at Inserts (we tried to approach 1,000 per second) MySQL generally kept pace in most other areas.

Hope this helps,

Michael

 

[alexhu]

What experience do youi have inhouse for these products ?

How much is it going to cost you in licensing, support and new staff to implement ?

Alex

 

[johnherman]

I would recommend Microsoft SQL Server over Sybase unless you have a compelling reason to avoid Windows platforms or a strong anti-M$ sentiment in your company. Oracle and SQL Server both have their plusses and minuses, as do all databases.

Is it a transaction system, reporting system or both? How many transactions per day? Is cost an issue?

It is my gut feeling that either MySQL, Oracle, or SQL Server on Windows will be the least expensive solution, followed by DB2 on Windows, and then any Unix (Sybase, Informix, Oracle, DB2) solutions. I do not recommend DB2 on Windows; in fact, do not recommend DB2 at all.

Sometimes the grass is greener on the other side because there is more manure there - original.

 

[parbhani]

Hi,

The application is not too huge of transactions, but still 1000 to 2500 inserts a day and reasonable updates.

We have enterprise license for Oracle.
Is MySQL really free for professional use ? I heard/read sometimes in past that MySQL does have some problems with very large and complex queries , is that true ?

In comparison which one is cheapest / costliest ?

Please add to the points.

Regards

 

[johnherman]

If you have an enterprise Oracle license, and are confident about the abilities of your staff to handle Oracle (DBA, programmers, etc), I would go with Oracle. It is the #1 database on Unix and is also a strong contender on the Windows platform. With that small transaction load, you might be able to piggyback on an existing server with an additional database instance.
---------

Sometimes the grass is greener on the other side because there is more manure there - original.

 

[pabloj]

I don't understand ho MySQL can be an option in an enterprise environment, it lacks stored procedures, views, triggers, check constraints (and many other advanced features), right now it is "just" simple and fast.
I would suggest to look for PostgreSQL (*nix and Windows platform support coming soon) of Firebird (an opensource fork of Borland's Interbase 6).
Also, I'm an happy user of SQLServer but it's clear to me that *nix (Linux and Solaris in my experience) is much more stable than Windows, this if you need your db to run 24x7x365 without expensive clustering solutions.
Hope this helps

Stick to your guns

 

[johnherman]

Remember that you have asked this question in an Oracle forum so do not be surprised if you get slanted results.

Have you asked this same question to the MySQK and toher forum?

Available for short and long term data warehousing consulting and contracts.