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 raquelribeiro_3@hotmail.com
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