Hi MonetDB uses internally dictionary compression for strings only. For the remainder it relies on the user to properly use the data types. For decimals types, it is known that the storage space is often larger then strictly needed.
Please sent a snippet of your database schema to assess the issues at more depth.
regards, Martin
On 6/18/11 2:51 PM, Ken Cheng wrote:
Hi All,
I am going to build a DW based on MonetDB. After check on the internet I found that MonetDB does not do data compression. Same data set in MonetDb is much bigger than MySQL and infoBright. Are there any plan to do data compression in the MonetDB?
Yours sincerely, Ken Cheng
EditLive Enterprise is the world's most technically advanced content authoring tool. Experience the power of Track Changes, Inline Image Editing and ensure content is compliant with Accessibility Checking. http://p.sf.net/sfu/ephox-dev2dev
MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users