Re: SQL or Oracle server?

You haven't really provided enough meat from which to make a meal. But basically if you go with SQL Server you are limited to a single architecture ... Microsoft on Intel. If you go with Oracle you can choose just about any hardware and operating system vendor.

Oracle gives you a far more robust piece of software when it comes to what really matters ... stability, security, and scalability. Not to mention Larry Ellison will cut you a check of a cool $1,000,000 if doing it with his software doesn't make your site run 300% faster than with anything Microsoft sells.

Then you get into the technical stuff such as row locking which SQL Server still doesn't really have, third-party products, etc.

I would also strongly suggest that you go to http://www.oracle.com and look at the white papers on Oracle version 9i. Because by the time you are ready to purchase the software 9i will be out. And 9i will devastate SQL Server when it comes to 7x24x365 and web access.

I would also suggest that you put together a specification of what it is you want to build and then come back with specific questions.

But in the end there is only one thing that really matters ... your resume. And a resume that says your built a web site with Oracle is worth about $20/hour more than one that says you did it with SQL Server. And $20/hr x $40 hrs/week * 50 weeks per year is real money.

Daniel A. Morgan

Dan Cohen wrote:

> Hi guys
>
> I have been given the task of purchasing a database system for a new
> companys web application. It has quite heavy usage requirements, and I have
> only ever worked with SQL server before. Can anyone tell me the pro's and
> con's, or maybe a short comparison between the two?
>
> Thanks in advance
>
> Dan
  Received on Mon Apr 23 2001 - 23:40:41 CDT