Subject Re: [firebird-support] Forces writes and transaction throughput?
Author Kjell Rilbe
Douglas Tosi wrote:

> On Wed, Dec 3, 2008 at 7:15 AM, Kjell Rilbe <kjell.rilbe@...
> <>> wrote:
> > I mean, with many many users, supposedly one of FB's strong points
> > considering it's locking mechanisms, there's bound to be a lot of
> > transactions. I can't really believe that the engine is limited to such
> > a low count of commits/second as I'm seing during this batch import.
> Please specify some real numbers. How many transactions/sec? What kind
> of hardware? How much is being done in each transaction? etc.

Well I did an import of about 10000 recors with about ten columns, no
BLOB:s but several varchars with widths up to 100-or-so but most values
a lot shorter. It took perhaps 10-20 minutes. That's with a commit on
each record, which I'm aware is not ideal and which is not what I'm
asking about.

Take it as an indication that FB can't commit more than about 15-20
transactions/second on my machine and configuration. Seems rather low,
to say the least. If that's as good as it gets it has to be a bottleneck
for a lot of people.

So, I want to know what, if anything, I should check/change to improve
my setup/config.

My machine is a AMD Athlon 64 X2 Dual Core, parallel SCSI 320 harddisks
with 10k rpm, 4 Gbyte RAM, Windows 2000. I have not set
CpuAffinityMask=1, which perhaps I should try, but then again, the
comment says the default is 1, so...(?)

Kjell Rilbe
E-post: kjell@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64