We have test monetdb for a while, I think it's a very good product especially for DW. most of the queries will be quite fast than sql 2008. but in these cases,you should be careful. 1 when you use functions on columns, the performance will be bad. (seems all column databases are like this, I asked some friends who have used sybase iq. they told me you'd better add new columns in ETL) 2 if your query need access many columns at a time 3 if your query need access many tables at a time, join performance it not very good. you'd better use 64 bit OS, and use big RAM. 2012/8/27 R@quel

Hi,

I have a question, i need comparison the execution query times between MonetDB and SQL 2008 in Data Warehouse (applying a different orientations database systems). But i have a problem, i used the AdventureWorkR2 2008 but i don't know how i can migrate the information to MonetDB.

To compare the same data.

Someone help me? Please. It's very important. Thanks,

Raquel -- View this message in context: http://old.nabble.com/Migration-DW-to-MonetDB-tp34348184p34348184.html Sent from the monetdb-users mailing list archive at Nabble.com.

------------------------------------------------------------------------------ Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users

-- 上海云数信息科技有限公司 http://www.cloudybi.com 联系人：李晓华 职务：总经理 手机：18616507502