Re: Size of SYS_INFO_sUSRSequence.koi file increases

Hi Arjav,

In a test situation where NEXTVAL is called in quick repetition you may 
see the growth of the size of the sUSRSequence file.  Mckoi adds a new 
entry to the sequence file for each sequence value created, and will 
reclaim the space from old entries when the system is less busy.  In an 
application when NEXTVAL is used to generate keys spread out over a 
longer session, you should not see unreasonable growth of this file. 
Mckoi should adopt a buffer size for the sUSRSequence file that matches 
your application's frequency of generating keys.

Toby.

Arjav Chakravarti wrote:
> Hello,
> 
> 	Our Java application uses the documented CREATE SEQUENCE and
> NEXTVAL commands to create and use the Mckoi sequence generator. We are
> using Mckoi 1.0.3.
> 
> 	The 001SYS_INFO_sUSRSequence.koi file started out with a size of
> 6120 bytes. I found that every call to NEXTVAL increased the file size
> by ~14 bytes. As a test, I called COMPACT TABLE on the
> SYS_INFO_sUSRSequence table after every call to NEXTVAL and found that
> the file size remained stable at 7144 bytes, even after 35000 calls to
> NEXTVAL.
> 
> 	Since our customers keep the application running for several
> months at a time, I am worried about database growth. I also want to
> avoid the overhead of frequent calls to COMPACT TABLE.
> 
> 	Is this a known issue with Mckoi? Any suggestions for how I
> could fix or work around this problem will be much appreciated.
> 
> Thanks,
> Arjav


---------------------------------------------------------------
Mckoi SQL Database mailing list  http://www.mckoi.com/database/
To unsubscribe, send a message to [email protected]