Bugs item #1982101, was opened at 2008-06-02 15:14
Message generated for change (Tracker Item Submitted) made by Item Submitter
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1982101&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: PF/runtime
Group: Pathfinder 0.24
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Wouter Alink (vzzzbx)
Assigned to: Nobody/Anonymous (nobody)
Summary: XQ: slowing down
Initial Comment:
MonetDB/XQuery slows down after each query. It seems to be related to the
complexity of the query. If running a simple query (for example "1+1") 10000
times, the first time it executes in .01 second. Then the execution time
gradually increases. The last time it executes in .05 seconds. Only restarting
mserver seems to reduce the execution time again to .01
The following script illustrates the problem:
n=0;
while [ $n -le 10000 ]
do
if [ $(($n % 100)) -eq 0 ]
then
clear
echo "Iteration $n"
time echo '1+1' | mclient -lxq > /dev/null;
fi
echo '1+1' | mclient -lxq > /dev/null;
n=$(($n + 1))
done
Is this expected behavior? (i know that 10000 times executing 1+1 is not really
a good example, but the same behavior is observed with more complex queries)
i'm using: MonetDB-preJune supersourcetarball (28-may-2008), Fedora Core 8,
64bit-oid
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1982101&group_id=56967
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Monetdb-bugs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
