--- In Firebird-Java@yahoogroups.com, "Roman Rokytskyy"
<rrokytskyy@a...> wrote:

>
> > Well, I already did this and they send me to this group... ;-)
>
> :)
>
> Ok, then can you create some test case that shows this issue (I
> understand that's easy, but it will save me some time which I can
> spare then on testing)? Maybe there's something JayBird specific,

but

> I doubt...
>
> Roman

Mhm, maybe something essential is wrong.
I create a database with 5 tables without any indices.
The tables looks like this:

CREATE TABLE MESSOBJEKTE ( MESSOBJEKTTYP INTEGER, MESSOBJEKTINDEX
INTEGER, MESSOBJEKT VARCHAR( 255 ), ZUSATZINFO VARCHAR( 255 ))

CREATE TABLE MESSWERTE (ZEITSTEMPELNUMMER INTEGER, MESSGROESSENID
INTEGER, MESSOBJEKTINDEX INTEGER, MESSWERT FLOAT)

CREATE TABLE ZEITSTEMPEL (ZEITSTEMPELNUMMER INTEGER, ZEITSTEMPEL
VARCHAR( 19 ))

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 ?