Second query run show the same stat : 0.9s

We do the same test with another procedure (with final application) and
the same degradation constated.

Statistic of gstat:

Before backup/restore :
Flags 0
Checksum 12345
Generation 8
Page size 4096
ODS version 10.1
Oldest transaction 3
Oldest active 4
Oldest snapshot 4
Next transaction 6
Bumped transaction 1
Sequence number 0
Next attachment ID 0
Implementation ID 16
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 3
Creation date Jul 7, 2005 11:04:31
Attributes

Variable header data:
*END*

After backup/restore :
Flags 0
Checksum 12345
Generation 30
Page size 4096
ODS version 10.1
Oldest transaction 1
Oldest active 2
Oldest snapshot 1
Next transaction 24
Bumped transaction 1
Sequence number 0
Next attachment ID 0
Implementation ID 16
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 3
Creation date Jul 22, 2005 10:38:46
Attributes

Variable header data:
Sweep interval: 20000
*END*

Regards.

Dom.


Ann W. Harrison a écrit :

> 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
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>
>