Hi, I think the problem is:
> delete from files where fileId>1000; This will result in index pages that are only partially filled. > update files set file=file||'.wav'; This will (basically) re-build the index, reducing the number of pages required. I will change the documentation of SHUTDOWN COMPACT: "COMPACT compacts the database (re-creating the database may further reduce the database size)". Regards, Thomas -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
