Subject | RE: [Firebird-Java] Re: Commit or commit retaining ? |
---|---|
Author | Евгений Путилин |
Post date | 2004-03-23T15:00:51Z |
Hi
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
records.
Eugeney
>And every minute I receive data from another host and write it to theHow count in table on insert with 8 sec?
>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 ?
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
records.
Eugeney