Bugs item #2889989, was opened at 2009-10-31 16:27
Message generated for change (Comment added) made by boncz
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: Peter Boncz (boncz)
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: Peter Boncz (boncz)
Date: 2009-11-17 00:54
Message:
I will take a look with a recent Nov2009 build
----------------------------------------------------------------------
Comment By: Stefan Manegold (stmane)
Date: 2009-11-02 20:00
Message:
"side not" -> "side note"
----------------------------------------------------------------------
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
------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
_______________________________________________
Monetdb-bugs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
