Hi,
In my machine which is very close to your setting (AMD 3800, 2G ram,
~100MB/s disk read) I get for hot run of q7
mclient -lxq --time < dblp_q7.xq
Trans 36.749 msec
Shred 6.051 msec
Query 44211.431 msec
Print 3.011 msec
Timer 44424.728 msec
which is almost 3 times more than your time. *But*, I just used my
current installation which is with debug-enable and
optimization-disable so these differences in execution times are
expected (you win 30-40% with optimization-enabled). So I would say
that your reported times are ok.
There are no indeces that you can additional ask. MonetDB maintains
the indeces it needs by itself.
Hope I was of any help.
regards,
lefteris
On Fri, May 9, 2008 at 11:28 AM, Nils Grimsmo
Using the "super-ball" from February.
I am running some queries, and just want to check if my performance is sane. Are there more indexes I can ask to get built to increase performance?
I don't ask for an accurate verification, just a hint of whether or not we are within an order of magnitude of what seems right :)
$ Mserver --dbinit="module(pathfinder);" --set mapi_port=60000
$ echo 'pf:add-doc("path/dblp.xml", "dblp.xml")' | mclient --lx -p60000 --time Timer 73068.138 msec
$ echo 'pf:documents()' | mclient -lx -p60000 <document updatable="false" url="path/dblp.xml" collection="dblp.xml">dblp.xml</document>
$ cat dblp_q7.xq count(doc("dblp.xml")/dblp/*[author="Michael Stonebraker" and author="Hector Garcia-Molina" and year > 1950 ]/title)
$ mclient -lx -p 60000 --time < dblp_q7.xq 4 Timer 15512.186 msec (Repeated multiple times for warm-up)
My dblp.xml is 441 MB. Mserver uses 1.9 of 3.4 GB memory.
$ cat /proc/cpuinfo <snip> model name : AMD Athlon(tm) 64 Processor 3500+ cpu MHz : 2210.763 cache size : 512 KB
The dbfarm resides on a WD740GD (http://techreport.com/articles.x/6390).
Klem fra Nils
------------------------------------------------------------------------- This SF.net email is sponsored by the 2008 JavaOne(SM) Conference Don't miss this year's exciting event. There's still time to save $100. Use priority code J8TL2D2. http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javao... _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users