I noticed my sql.data file is not shrinking.
Does "DROP TABLE foo" work with tables that were created CACHED? Database.dropTable() might work with memory tables but I think there needs to be someplace dead row are cleaned up. 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 ........................................................... : 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