Bugs item #2889989, was opened at 2009-10-31 16:27
Message generated for change (Comment added) made by stmane
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2889989&group_id=56967
Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: XML
Group: None
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: winston (wwinston)
Assigned to: Nobody/Anonymous (nobody)
Summary: MonetDB4/XQuery Extremely Slow on Vista 64-bit
Initial Comment:
I installed MonetDB4/XQuery 32-bit on (1) Windows XP 32-bit, and (2) Windows
Vista 64-bit. I need to use the exact same MonetDB version.
For example, when I compare the two using the XPath (XQuery)
"//open_auction//description//listitem//keyword" on XMark database size=0.005:
(1) On Windows XP the query takes: 0.016 seconds and returns 47 rows.
(2) On Windows Vista the query takes 18.7 seconds to return the same 47 rows.
This demonstrates that Vista runs this application 1000x SLOWER than on Windows
XP.
The computer is a new Dell laptop, with 8GB Ram and 2GH processer. The
processor speeds are the same on the XP and Vista boxes.
I uninstalled the McAfee virus checker thinking it was the problem and
installed Microsoft One Care (also installed on the XP machine), but there is
no change in the performance.
What is going on here? Why is Windows Vista so excruciatingly SLOW for
MonetDB, 1000x slower, when compared to Windows XP?
Any idea how to improve MonetDB performance on Vista?
----------------------------------------------------------------------
>Comment By: Stefan Manegold (stmane)
Date: 2009-11-02 19:59
Message:
As a side not In this context, not knowing whether it is indeed related, I
just recall that I experienced some quite slow performance when trying to
run our nightly testing of 32-bit Windows on a 64-bit Windows server ('ver'
says "Microsoft Windows [Version 6.0.6001]", hence, I guess this is some
Vista server version) --- I did not analyze this any further and cannot
tell whether the slow performance was only with running the tests (i.e.,
running MonetDB) or also with compiling MonetDB ...
----------------------------------------------------------------------
Comment By: Sjoerd Mullender (sjoerd)
Date: 2009-11-02 19:15
Message:
Would it be possible to install the 64 bit version of MonetDB on your Vista
and try the experiment again? I don't have a 64 bit Vista on bare metal to
try this on, and I doubt running it in a virtual machine gives reliable
timing results.
----------------------------------------------------------------------
Comment By: winston (wwinston)
Date: 2009-10-31 17:37
Message:
BTW: The measurements were taken from a Java program using the 1.14 client
jar.
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2889989&group_id=56967
------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
Monetdb-bugs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
