Re: sql vs oracle

Hello,

        MS SQL Server 6.5 is very capable of supporting the system you described. For over a year, I supported a OLTP 6.5 system with 20 gb db and over 400 concurrent users on a Compact 5000 4x200 with no problems. If I had to choose a UNIX platform, I 'd choose Sybase because the learning curve from MSSQL to Sybase is minimal - 99.9% of the SQL code is portable. And besides, Oracle is not the better UNIX RDBMS when compared to Sybase ASE 11.5.1 ( or, just released today, ASE 11.9.2 which support row level, page and table locking )

I work with MSSQL, Sybase AND Oracle and this is my opinion.

Please not flames. It's my opinion.

Robert
abpitg_at_ibm.net

Naushi Hussain wrote:
>
> Following is the dialogue between me and a project leader for an
> upcoming project. The argument is about what DBMS are we going to use.
> DB size is 7GB.20k transactions/day. Can someone say anything in support
> of sql.
>
> Naushi,
>
> Is there a preferred state of being for our databases? For example, do
> we prefer to put Oracle on NT and SQL on UNIX?
>
> Could you please let me know? The versions of the software (DBMS & OS)
> would also be appreciated. I need to know by Wednesday morning.
>
> Thanks!
>
> Hal
> -------
>
> Hal!
>
> The bottom line is:
>
> When it comes to using NT (4.0) as the OS for a DBMS, SQL Server (6.5)
> works better than any other DBMS - They say SQL Server to NT is like
> peanut butter to jelly.
>
> But SQL Server has its limitations - based on my experience and talking
> to other gurus, you want to select Oracle(7.x - we are not going to use
> 8.0 yet) or Informix ( I guess Informix is out) if you are going to have
> more than a hundred concurrent users and your database size is more than
> 50GB. You also want to use UNIX (4.x) for a complex environment (100+
> users, 50+gb database and heavy transactions 30k+ per day) since NT has
> its limitations too, but NT limitation is not a serious issue. SQL
> Server works only on NT while Oracle works on both.
>
> SQL Server is just coming up with 7.0 which should reduce its
> limitations by far. I guess we are not going to wait for that to be
> proved.
>
> I hope I answered your questions. If I can be of further assistance
> please let me know.
>
> Naushi
> -------------------------------
> Naushi,
>
> Based on what you write, we will be going with Oracle since we may have
> more than 100 concurrent users. The next question is that while Oracle
> works with both OS, do we have a preference?
>
> Thanks!
>
> Hal
  Received on Fri Sep 18 1998 - 00:00:00 CEST