Subject Re: [firebird-support] Re: Large row count in tables
Author Dimitry Sibiryakov
> Executing...
> Done.
> 197255 fetches, 45140 marks, 25000 reads, 28780 writes.
> 9660 inserts, 0 updates, 0 deletes, 0 index, 0 seq.
> Delta memory: 10964 bytes.
> TYPE_128: 9660 inserts.
> 9660 rows affected directly.
> Execute time: 00:01:23.
> Script execution finished.
>
> Record count: 19459137
>
> As you can see, it still takes a minute to insert those 9660 rows, which is to slow for my needs.

I think that actual insert takes a couple of seconds, and the rest of
time server is busy with select which output this "Record count: 19459137".

SY, SD.