At 09:40 PM 20/08/2004 +0200, you wrote:

>Helen Borrie wrote:
>
> > ...
> > With the Xeons, it's also worth testing things with SS and both
> > processors. On some motherboards, it's been reported that SS balances
> > perfectly across 2 or 4 Xeons. For that you'll need to configure the cpu
> > affinity in firebird.conf.
> > ...
>
>
>Could you expand on this? It seems rather strange ...

At the moment, no. I was talking with a guy from a company in Canberra
recently, that uses Firebird as the back-end to a product with wide
coverage in retail pharmacies here. The company supplies the software,
hardware and support as a bundle.

The fellow I spoke with told me that, because they were in the position to
test on just about anything, they tested SMP configurations exhaustively
and came up with this one Xeon/??motherboard combination that didn't
display the see-saw effect and ran Firebird SS in production happily
balancing the load at around 17% across 4 Xeons.

At the time we talked, he hadn't documented it, but said he would do so and
get back to me. I must follow it up...

./heLen