Thanks for response.
Currently, I am using MySQL to store Websphere MQ statistics for our software product.
Clients begin complaining about reporting performance once the size goes beyond 3-4mill records :)
I tried BDB XML (latest), but after loading 50K xml records into collection it takes many hours to start :)
I loaded around 5 million same XML records into MonetDB and still have great performance.

Thanks.
-Max

On Tue, Apr 14, 2009 at 12:23 PM, Martin Kersten <Martin.Kersten@cwi.nl> wrote:
Max Fedorov wrote:
> The product looks very promising on paper, although not that many people
> are talking about it and I came across MonetDB by accident.
> Is anyone using MonetDB in production?
> Is the product stable enough?
> I do not feel like spending lots of time testing this XQuery server if
> nobody runs it in production.
> I loaded several million records and tested sample queries without
> issues for the most part, but then once the server just vanished
> (running latest 32bit version on WindowsXP). I restarted and everything
> is working again, but now I am very scared. Nothing like this ever
> happened when using MySQL, MS SQL Server or Oracle. Nothing ever just
> dies without a trace.
Max,

Thanks for trying out the XQuery package.

I guess you have been using either Oracle or MySQL system to run
a realistic XQuery workload. If so, we would like to learn the
experiences in relationship to those.

You might consider the size of your database in relationship to the platform
you are using. And the characteristics of MonetDB as a database engine
that squeezes performance out of it. If a process dies without a trace,
and deals with these sizes on a small platform, then it is not unlikely
that the OS has identified it as a victim to free up resources.
The recovery mechanism ensures that the data is not lost.

FYI, one of the customers using the XQuery engine on a daily basis
is the Dutch Forensics Institute.


regards, Martin Kersten
>
> Thank you.
> -Max
>
>
> ------------------------------------------------------------------------
>
> ------------------------------------------------------------------------------
> This SF.net email is sponsored by:
> High Quality Requirements in a Collaborative Environment.
> Download a free trial of Rational Requirements Composer Now!
> http://p.sf.net/sfu/www-ibm-com
>
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> MonetDB-users mailing list
> MonetDB-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/monetdb-users


------------------------------------------------------------------------------
This SF.net email is sponsored by:
High Quality Requirements in a Collaborative Environment.
Download a free trial of Rational Requirements Composer Now!
http://p.sf.net/sfu/www-ibm-com
_______________________________________________
MonetDB-users mailing list
MonetDB-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/monetdb-users



--
Max Fedorov
Netflexity, Ltd.
tel: 267-408-3699
fax:888-201-7922
www.netflexity.com