Subject RE: [Firebird-Java] Re: Commit or commit retaining ?
Author Евгений Путилин
>And every minute I receive data from another host and write it to the
>database, especially in two of the 5 tables. I use preparedStatement
>and commit. I insert about 2000 records every minute.
>When I start the application the inserts lasts about 500 ms. After
>4 hours the time for inserts is about 8 seconds.
>Is this normal ? Or can I do something to speed up the inserts ?
How count in table on insert with 8 sec?

You may create very big db for test. After do gbak/restore date. And
insert new value, you see time for insert when table contain many