Thanks for your reply Brent. It was really useful.
Looks like Opteron would be a good choice since there
wont be several multiple queries at the same time but
instead we will be happy if the single query runs
fast. You had mentioned adding more RAM would help,
how much RAM would be ideal ? Does the
Tough question since a lot of performance is dependent on how you
structure your queries, your database design and indexing.
But, going with what you provided...
You have big tables, so you will want lots of RAM. That means a 64bit
system like Opteron, Itanium or PowerPC based (ok and Xeon). Pow
