Hi,
Does anyone have advice on processor speed and memory size for the size of data your working with?

I have a 2,000,000 row table joined to a 5,000,000 row table and am trying to output 20 columns in a view, but the query times out.

The system I'm using has dual 450's and a half a gig of ram. I would think that would be enough, but am having performance problems with large datasets.

Thanks
Dale