Which SQL is the best for servers?

From: pg <penang_at_catholic.org>
Date: Sun, 15 Feb 2009 22:09:05 -0800 (PST)
Message-ID: <dd9edcff-7d7f-49ca-bddd-2b7bba050310_at_l33g2000pri.googlegroups.com>



I am involved with a SQL server project. The server would be used in a very heavy duty environment, with hundreds of thousands, if not millions of database enquiries per minutes.

The server would run Linux or one of the BSD variant, with at least 32GB of RAM. We are not very certain of the hardware specs yet because we haven't decided on which SQL to use.

I know that Oracle, MySQL and PostgreSQL are all designed for heavy duty uses.

And I checked all available online resources for a SQL comparison and all I could find is some articles dated 2005 or so !

So, here's my questions:

  1. Are there any recent SQL comparison article available?
  2. Since the server may come with only 32GB of RAM, which SQL can run the "leanest" - that is, not a memory hog?
  3. The server might also become a web-server, which SQL can tie itself to the Web-based enquiry they best?

Please give me your suggestion / opinion. Thank you !! Received on Mon Feb 16 2009 - 00:09:05 CST

Original text of this message