Subject | Re: [ib-support] insert in Firebird |
---|---|
Author | C R Zamana |
Post date | 2001-08-29T15:37:52Z |
Ivan Prenosil wrote:
Well, a gstat -h <file.gdb> give me the following:
Database header page information:
Flags 0
Checksum 12345
Generation 13
Page size 4096
ODS version 10.0
Oldest transaction 5
Oldest active 6
Oldest snapshot 6
Next transaction 7
Bumped transaction 1
Sequence number 0
Next attachment ID 0
Implementation ID 19
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 1
Creation date Aug 29, 2001 12:14:39
Variable header data:
Sweep interval: 20000
*END*
Anyway, how this flag affect the performance of my batch process?
Thank you.
Best regards.
--
------------------------------------------------------------------------
zamana@... | "Emacs is a nice OS - but it lacks a good text
zamana@... | editor. That's why I'm using Vim. Anonymous
http://www.inso.com.br | http://www.vim.org/quotes.html
------------------------------------------------------------------------
>>>Do you have forced writes ON ?Thanks.
>>>
>> How can I check this?
>>
>
> e.g. by gstat utility
> (gstat -h c:\db.gdb)
Well, a gstat -h <file.gdb> give me the following:
Database header page information:
Flags 0
Checksum 12345
Generation 13
Page size 4096
ODS version 10.0
Oldest transaction 5
Oldest active 6
Oldest snapshot 6
Next transaction 7
Bumped transaction 1
Sequence number 0
Next attachment ID 0
Implementation ID 19
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 1
Creation date Aug 29, 2001 12:14:39
Variable header data:
Sweep interval: 20000
*END*
Anyway, how this flag affect the performance of my batch process?
Thank you.
Best regards.
--
------------------------------------------------------------------------
zamana@... | "Emacs is a nice OS - but it lacks a good text
zamana@... | editor. That's why I'm using Vim. Anonymous
http://www.inso.com.br | http://www.vim.org/quotes.html
------------------------------------------------------------------------