Thanks for your responces.
But we feel we have already optimised the code to its full
potential.
It is at the hardware level where we need to start looking.
We have a single process injecting and updating data from
an external source. There are no clients all work
is done in a single process on the server machine.
We need to know how we can optimise the hardware with firebird,
without a trial and error approach which would cost heaps of
money and time to decipher how to build a machine that can
take firebird to its maximum potential

Regards,

Robert.