Re: Which hardware ?

On Tue, 17 Jun 2008, Lionel wrote:
> I need to install a 8.3 database and was wondering which hardware would be
> sufficient to have good performances (less than 30s for² slowest select).

> It's almost impossible to predict what users will do via the webapplication
> that queries this database: almost all select, join, group by, where...
> possibilities are available.

Well, Scott has given you some good pointers on how to make a fast system.
However, your original question ("is this fast enough") is impossible to
answer, especially if the users are allowed to run absolutely anything
they want. I bet you I could craft a query that takes more than 30 seconds
regardless of how fast you make your system.

Having said that, I'll add the suggestion that you should put as much RAM
in the box as possible. It can only help. As others have said, if you only
have four users, then CPU power isn't going to be such a problem, and
given that, I'd disagree with Andrew and say as long as you have plenty of
RAM, Java can play well with a database on the same box. Depends what it
is doing, of course.

Matthew

--
To be or not to be -- Shakespeare
To do is to be -- Nietzsche
To be is to do -- Sartre
Do be do be do -- Sinatra