I'd expect databases to have quite odd performance characteristics
compared to a more normal application though; You'd expect them to be IO
bound most of the time, so having more threads than cores sounds like a
reasonable thing to do.
If you aren't waiting on the disc, then more threads aren't going to
help, they'll just be contending for cpu time as BCS said.
Still that's one of the drawbacks with multi threading, there's really
not many absolute statements you can make or things you can assume.
You'll have to profile you application and fiddle with it to find out
how to get the best performance out of it.
Yeah, that was my assumption. It just sounded like there was more to it.
Thanks.
Casey
