Paul R. Gardner wrote:

>> Could you define more closely what "slow" means. How many records per
>> second?
>
> Between 15 and 100 records per second depending on record size and how many
> concurrent tables are being processed.

This doesn't look right. I typically get 10.000-20.000 per second on
average hardware with forced writes and triggers active.

Are you using prepared statements?

> Firebird's processor usage won't go above 30% and is typically around 5%.
> CPU Affinity is set to 15.

Low CPU usage usually means that either something is wrong with context
switching or CPU is waiting for disk I/O.

Do you by any chance have hyperthreading enabled for CPU? I've seen one
case where disabling hyperthreading in BIOS made similar problems go away.

Also, are your hard disk(s) running in PATA, SATA or some Mixed,
Combined or Enhanced mode? Can you switch to pure SATA, or sata-only as
some producers call it? I should also be a setting in BIOS. You could
also try installing updated version of sata drivers for Windows (if
available). I've seen this help fix similar problems on some Windows
machines.

HTH

--
Milan Babuskov

==================================
The easiest way to import XML, CSV
and textual files into Firebird:
http://www.guacosoft.com/xmlwizard
==================================