>I'm also concerned about speed. Putting code next to the data on the same physical box seems logical, but then am I missing something about how a distributed app works in .Net?

As long as the box has enough cycles to spare this should be faster. But if you need to scale to more/multi-cpu machines this might give you higher licensing costs and the performance might not be faster.

my 0.02 EUR

thomas