Era il 11:26, mercoledì 26 novembre 2003 quando Arno Brinkman, forse in
preda ai fumi dell'alcool, scrisse:

> Hi,

[CUT]

> Do you commit the transaction every time after that you've read the
> reocrds for information on video ?

No, I dont commit after select rows.
Can be that the problem?
I dont know it is needed.
Firebird create a new record version on select?

Yesterday I went to my costumer. In the meantime he shutdown the server and
performance are good now.
I modified my app so that it connect, select and than disconnect from
database. Also I have set autocommit on.

By reply to Svein also:
I run a gstat after shutdown and the result is:

Database header page information:
        Flags                   0
        Checksum                12345
        Generation              7984877
        Page size               4096
        ODS version             10.1
        Oldest transaction      7831719
        Oldest active           7980739
        Oldest snapshot         7980739
        Next transaction        7980740
        Bumped transaction      1
        Sequence number         0
        Next attachment ID      124539
        Implementation ID       16
        Shadow count            0
        Page buffers            0
        Next header page        0
        Database dialect        3
        Creation date           Nov 18, 2003 21:10:55
        Attributes              force write

Now I have to wait about a week to see performance.
 

> Regards,
> Arno Brinkman
> ABVisie

Thank you
Ciao

PS: sorry for my poor english
--
Andrea Chiado' Piat
Bit Informatica srl