dominique.barrieu wrote:

>
> We carry out the following procedure:
> - Run script of creation of the data base with primary key, foreign key
> and index
> - Run data insertion script
> - Run a querry with isql. The stat gives a time of 0.16s
> [backup, restore, rerun query 0.9s]

You don't show starting and stopping the server. My guess is that what
you're seeing is server startup overhead - reading metadata etc. What
happens if you time not the first run of the query but the second?

>
> PS: after restore the data base is 10% smaller than orrigine...
>

Gbak builds indexes after inserting data (called a bulk load) and gets
much higher index compression.

Regards,


Ann