How to reduce the size of .mgbmp file ?

[netwenchao]

How to reduse the size of .mgbmp file ? RemoveKey only remove key from idx and mark the storageitem in *.mgbmp as deleted.

But the file size has not decreased.
Is there anyway to remove storageitem from raptordb??

[mgholam]

The bitmap index has an Optimize() method which is currently only being used by the hOOt full text index, I will add this to all other indexes.

No you can't remove a StorageItem as it is by design, if you are working with transient data use the high frequency storage instead.

Thanks.

[netwenchao]

The bitmap index has an Optimize() method which is currently only being used by the hOOt full text index, I will add this to all other indexes.

No you can't remove a StorageItem as it is by design, if you are working with transient data use the high frequency storage instead.

Thanks.

After the system has been running for a while, the size of the .mgbm file is increasing (currently 7G). I need to periodically delete the old data to reduce the disk space.

But the most recent data needs to be retained. Is there any other way?

[mgholam]

Ah! Interesting.

Can you answer a few questions for me:

• How many items are in your view?
• Can you post a "dir" of the view folder contents (with the 7gb index)?
• How big is the docs folder?