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
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