Subject Re: [ib-support] insert in Firebird
Author C R Zamana
Ivan Prenosil wrote:
>>>Do you have forced writes ON ?
>>>
>> How can I check this?
>>
>
> e.g. by gstat utility
> (gstat -h c:\db.gdb)

Thanks.


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
------------------------------------------------------------------------