Size of SYS_INFO_sUSRSequence.koi file increases

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]