Subject Re: [firebird-support] Re: Large row count in tables
Author Pavel Cisar
roar4711 napsal(a):
>
> As you can see, it still takes a minute to insert those 9660 rows,
> which is to slow for my needs.

That's really strange. Such simple row without indices should insert at
speed at least 400 rows per second or better on average HW, while your
throughput is ~100 rows per second. If you're interested to see how fast
rows could be stored into your table without indices and triggers
involved on your HW, you may simply backup it with gbak and then restore
it with -v option (so you'll get printouts during restore) and watch the
output as it goes. gbak prints report line for each 10000 records
inserted. If it's faster than your routine, then you did something wrong
in it and should focus on fixing it. If not, then you could try to
configure the FB and environment or get better HW, as you can hardly
beat gbak in insert speed.

best regards
Pavel Cisar