>1) You keep (at least) one transaction open.


>>> Oldest active 2
>>> Next transaction 231


>The gap between oldest active and next transaction ought to be small. Since
>your database is pretty new the gap isn't very big yet, but you have to
>commit occationally. Just something to be aware of.

I don't understand that, this database is freshly backuped/restored

> 2) Most of your indexes contain lots of duplicates


>>> Depth: 2, leaf buckets: 367, nodes: 487329
>>> Average data length: 0.00, total dup: 487327, max dup: 32730


> This will make updates and deletes slow. Either drop such indexes or add
> the primary key to the end of the index.

Thanks for the advice


--
Philippe Makowski
A6-CMO
20 rue Martin Bernard 75013 Paris France
Téléphone/Office : +33 1 53 62 71 51
Ligne Directe/Direct line : +33 5 61 05 88 13
Fax : +33 1 53 62 71 54
http://www.a6cmo.fr

Firebird serveur SQL open-source en français
http://firebird-fr.eu.org

Ma clé PGP : http://makowski.eu.org/pgpkey.html