Re: Which SQL is the best for servers?
From: The Natural Philosopher <a_at_b.c>
Date: Mon, 16 Feb 2009 07:43:37 +0000
Message-Id: <1234770217.12398.1_at_proxy02.news.clara.net>
Jack wrote:
>> 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 !!
Date: Mon, 16 Feb 2009 07:43:37 +0000
Message-Id: <1234770217.12398.1_at_proxy02.news.clara.net>
Jack wrote:
> "pg" <penang_at_catholic.org> wrote in message > news: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 !!
> Hi! > > Well, use Oracle database. If needed use RAC/GRID, if you really have so > heavy dyty usage ;) > But you could try with single server. (and later take GRID and add more > nodes, if usage growns) > > Do not put web-server into same box (server) as database. >
There speaks a man who looks like he is posting from the oracle group.
From my far more limited knowledge, it makes sense to me.
> HTH > Jack > >Received on Mon Feb 16 2009 - 01:43:37 CST