Re: Writing to compressed table
This will not come in the near future. The existing compression algorithm needs exact statistics information of the table. It will not work with data added in the future. Hence, a new compression algoritm needs to be developed, which, however, cannot be of the same efficiency, as it needs to estimate how future data records look like and needs to allow for unexpected deviation from the estimation.
There are however short-term plans for a new SQL like command that allows to compress a table. So that one does not need the 'myisampack' utility any more. Proper locking of the table is then implicit.
Subject
Views
Written By
Posted
3350
May 26, 2005 07:55AM
Re: Writing to compressed table
2300
May 27, 2005 01:52AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.