Hi all,

Continuing discussion about my database file size which is keep growing
along with application access to the database, especially with Helen. I got
the database statistic like this:

---
Database header page information:
Flags 0
Checksum 12345
Generation 29137
Page size 1024
ODS version 10.0
Oldest transaction 29128
Oldest active 29129
Oldest snapshot 29129
Next transaction 29130
Bumped transaction 1
Sequence number 0
Next attachment ID 0
Implementation ID 19
Shadow count 0
Page buffers 1024
Next header page 0
Database dialect 3
Creation date Jun 22, 2003 18:05:27
Attributes

Variable header data:
Sweep interval: 20000
*END*
---

I got it from IBConsole Database Statistic, after I run my application for
the first time. What are those meanings? I don't understand. Please, explain
it to me. Perhaps from the explanation, I can figure out where the problem
arised from.

Though I don't quite understand, I assume that the 'Next transaction' item
is the number of transaction which has not done yet and going to be done by
the database. Is it correct? If it is, which transactions? because as you
can see at my previous email about the pseudo-code of my application, I
always commit (retain) everytime I did update.

For any kind of responses, I thank you in advance.

Regards,

-Bee-