In my experience this is probably not going to work very well for you... especially if you are continuing to load data at the same time.  I usually use MonetDB to load data and process it, then move simplified/aggregated data to another database for user presentation.<div>

<br></div><div>You&#39;re still going to have to be very careful with MonetDB, depending on the volume of incoming data you&#39;ll need to restart the database at least a couple of times a day.</div><div><br><div class="gmail_quote">

On Mon, May 17, 2010 at 8:50 AM, dariuszs <span dir="ltr">&lt;<a href="mailto:dariuszs@svnp.com">dariuszs@svnp.com</a>&gt;</span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">

Hi,<br>
So what happens (performance wise) when you have 50GB of memory, 300GB<br>
of data and on average 100 concurrent users using all the tables and<br>
columns in your database? Thanks. Dariusz.<br>
<br>
<br>
<br>
------------------------------------------------------------------------------<br>
<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></div>