Re: Which SQL is the best for servers?
From: hpuxrac <johnbhurley_at_sbcglobal.net>
Date: Mon, 16 Feb 2009 16:00:36 -0800 (PST)
Message-ID: <dbe2edca-3efe-4e47-9a4f-8cd1990b4793_at_l37g2000vba.googlegroups.com>
On Feb 16, 1:09 am, pg <pen..._at_catholic.org> 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 16:00:36 -0800 (PST)
Message-ID: <dbe2edca-3efe-4e47-9a4f-8cd1990b4793_at_l37g2000vba.googlegroups.com>
On Feb 16, 1:09 am, pg <pen..._at_catholic.org> 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 !!
Hundreds of thousands or millions of queries per minute on 1 32 gig server?
Sounds pretty unlikely.
Oracle or DB2 are probably the only 2 viable choices but it doesn't sound like a good plan from the get go. Received on Mon Feb 16 2009 - 18:00:36 CST