We have test monetdb for a while, I think it&#39;s a very good product especially for DW.<div>most of the queries will be quite fast than sql 2008.</div><div><br></div><div>but in these cases,you should be careful.</div><div>
<br></div><div>1 when you use functions on columns, &nbsp;the performance will be bad.</div><div>&nbsp;&nbsp; (seems all column databases are like this, I asked some friends who have used sybase iq. &nbsp;they told me you&#39;d better add new columns in ETL)</div>
<div>&nbsp;&nbsp; &nbsp;</div><div>2 if your query need access many columns at a time</div><div><br></div><div>3 if your query need access many tables at a time, join performance it not very good.</div><div><br></div><div>you&#39;d better use 64 bit OS, and use big RAM.&nbsp;</div>
<div><br></div><div><br></div><div><br></div><div><br><br><div class="gmail_quote">2012/8/27 R@quel <span dir="ltr">&lt;<a href="mailto:raquelribeiro_3@hotmail.com" target="_blank">raquelribeiro_3@hotmail.com</a>&gt;</span><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><br>
Hi,<br>
<br>
I have a question, i need comparison the execution query times between<br>
MonetDB and SQL 2008 in Data Warehouse (applying a different orientations<br>
database systems). But i have a problem, i used the AdventureWorkR2 2008 but<br>
i don&#39;t know how i can migrate the information to MonetDB.<br>
<br>
To compare the same data.<br>
<br>
Someone help me? Please. It&#39;s very important.<br>
Thanks,<br>
<br>
Raquel<br>
--<br>
View this message in context: <a href="http://old.nabble.com/Migration-DW-to-MonetDB-tp34348184p34348184.html" target="_blank">http://old.nabble.com/Migration-DW-to-MonetDB-tp34348184p34348184.html</a><br>
Sent from the monetdb-users mailing list archive at Nabble.com.<br>
<br>
<br>
------------------------------------------------------------------------------<br>
Live Security Virtual Conference<br>
Exclusive live event will cover all the ways today&#39;s security and<br>
threat landscape has changed and how IT managers can respond. Discussions<br>
will include endpoint security, mobile security and the latest in malware<br>
threats. <a href="http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/" target="_blank">http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/</a><br>
_______________________________________________<br>
MonetDB-users mailing list<br>
<a href="mailto:MonetDB-users@lists.sourceforge.net">MonetDB-users@lists.sourceforge.net</a><br>
<a href="https://lists.sourceforge.net/lists/listinfo/monetdb-users" target="_blank">https://lists.sourceforge.net/lists/listinfo/monetdb-users</a><br>
</blockquote></div><br><br clear="all"><div><br></div>-- <br>上海云数信息科技有限公司<div><a href="http://www.cloudybi.com" target="_blank">http://www.cloudybi.com</a></div><div>联系人：李晓华</div><div>职务：总经理</div><div>手机：18616507502</div>
<br>
</div>