A Question about Dual CPU systems

[Tom Droege <tdroege2@earthlink.net>]

Now that I am running production on the data, I am thinking about how to 
make the process go faster.  I am thinking about a dual cpu mother board.

I assume that such a system does not make the pipeline run faster.  Is this 
true?  Seems to me that the code would have to know about the available cpu 
and this would take a lot of special code.

I assume that what a second processor would buy me is the ability to 
simultaneously work on the data while the pipeline was running at little 
loss of power.  Is this true?

Does a dual cpu system make economic sense.  I.e. are they so expensive 
that I would be better off running two computers and getting a network 
going to move the data around?

Anyone have any recommended place to buy a dual cpu bare bones system?

Tom Droege