Subject | Re: [firebird-support] Re: Large row count in tables |
---|---|
Author | Pavel Cisar |
Post date | 2009-08-04T15:06:41Z |
roar4711 napsal(a):
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
>That's really strange. Such simple row without indices should insert at
> As you can see, it still takes a minute to insert those 9660 rows,
> which is to slow for my needs.
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