> DROP [CACHED] TABLE does not clear the .data file. > The data remains with an > index root that is no longer used or accessed.
Thats what I thought but I hoped I was wrong. The data files grow for ever with every insert and delete. >Will > have to address this and > a few other issues such as the free list very soon. ok > > There have been comments that the indexing used for > the cache is not > efficient etc. but the real problem with the cache > is it was never fully > integrated into the Hypersonic code. Mark Tutt > revolved some very basic > issues for version 1.6.0, and there are more > improvements introduced into > 1.7.0 RC3. We'll just need to make a concerted > effort among the developers > who are familiar with the workings of the Cache and > Index classes and sort > out all the outstanding issues. I have some ideas for this. I will submit some sample code that used NIO in a few days. ===== Karl Meissner ........................................................... : Meissner Software Development, LLC : : "Software development and project management services." : : http://meissner.v0.net/resume.htm : ........................................................... __________________________________________________ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ _______________________________________________ hsqldb-developers mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/hsqldb-developers
