#13 Table cannot be optimized / repaired

[Anonymous]

Hello,

I'm using SmallSQL for the internal database of my Java Desktop App. The problem is the *.sdb file keeps growing as I insert more rows. I already tried TRUNCATE & DELETE, but it does not remove the data physically from the file.
In MySQL, deleted rows from a table can be physically removed using OPTIMIZE and REPAIR, but it cannot be done in SmallSQL.

Are there any workaround in SmallSQL to clean the table so it won't be bloated ?

Thank you,
Reggio
reggionh at hotmail dot com

[Nobody/Anonymous]

Logged In: NO

Yes, this is a problem in the current version. I hope that I can make a version this year that add this feature.

Volker

[Nobody/Anonymous]

Logged In: NO

Hallo,

OK I see.. I finally decided just simply to drop and re-construct the table as a workaround to my problem. I'm looking forward for OPTIMIZE or REPAIR feature in SmallSQL =)

vielen Dank und Grüße aus Indonesien,
Reggio

[Anonymous]

Hi, I'm using Smallsql, and I have the same problem as the user who started this thread, when I insert new file. sdb continues to grow, I tried to erase all data before doing the insert, but does not work, as I saw a user said that maybe in the next version are solved, I am using version 0.20, and would like to know if that fixes the problem or continues. Thank you very much

[Small SQL]

Currently I does not work on on a feature to solve it.

Volker