DROP [CACHED] TABLE does not clear the .data file. The data remains with an index root that is no longer used or accessed. Will have to address this and a few other issues such as the free list very soon.
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. Fred Does "DROP TABLE foo" work with tables that were created CACHED? There is a free list in Cache but it does not look like it gets saved between sessions. So this will also leave dead rows in the data file too. Sorry if I am just not getting the code. Karl ===== Karl Meissner _______________________________________________ hsqldb-developers mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/hsqldb-developers
