4-way SMP Opteron system is actually pretty damn cheap -- if you get
2xDual Core versus 4xSingle. I just ordered a 2x265 (4x1.8ghz) system
and the price was about $1300 more than a 2x244 (2x1.8ghz).
Now you might ask, is a 2xDC comparable to 4x1? Here's some benchmarks
I've found that showing D
> This can often be called for. I'm working on a 400GB data warehouse right
> now, and almost *all* of our queries run from materialized aggregate tables.
I thought that was pretty much the definition of data warehousing! :-)
--
Mike Nolan
---(end of broadcast)-
Joel,
> The two worst queries (our case and audit applications) I created
> denormalized files and maintain them through code. All reporting comes off
> those and it is lightning fast.
This can often be called for. I'm working on a 400GB data warehouse right
now, and almost *all* of our queries
Thank you much for the info.
I will take a look. I think the prices I have been seeing may exclude us
getting another 4 proc box this soon. My boss asked me to get something in
the 15K range (I spent 30 on the Dell).
The HP seemed to run around 30 but it had a lot more drives then the dell
(speced
On Thu, May 12, 2005 at 08:54:48PM +0200, Manfred Koizar wrote:
> On Wed, 11 May 2005 16:15:16 -0500, "Jim C. Nasby" <[EMAIL PROTECTED]>
> wrote:
> >> This is divided by the number of index columns, so the index correlation
> >> is estimated to be 0.219.
> >
> >That seems like a pretty bad assumpti
If you make the assertion that you are transferring equal or less
session data between your session server (lets say an RDBMS) and the
app server than you are between the app server and the client, an out
of band 100Mb network for session information is plenty of bandwidth.
So if you count on a m
