;;
<[EMAIL PROTECTED]>
Sent: 08 April 2002 14:27
Subject: Re: [Hsqldb-developers] DROP Table
> 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
file
> 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
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
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
