Hi Stefan, I have Monet DB4, Mserver v4.32.0 , mclient for xquery and I have the Aug09 release for windows 32-bit. The queries that I'm runing is FLWOR expressions, basically is just a searching in some xml files. I'm sure that the execution time increases and its not that I take the sum of all times, because I can see it from the respond of the shell. Here is an example of running the same query 3 times: (1st time) Trans 1548.000 msec Shred 422.000 msec Query 344.000 msec Print 0.000 msec Timer 2638.072 msec (2nd time) Trans 1438.000 msec Shred 16.000 msec Query 1423.000 msec Print 0.000 msec Timer 3115.265 msec (3rd time) Trans 1454.000 msec Shred 0.000 msec Query 2095.000 msec Print 0.000 msec Timer 3784.248 msec I searched the configuration file to increase the memory or anything tha could help but nothing helped..

Date: Mon, 5 Oct 2009 12:42:18 +0200 From: Stefan.Manegold@cwi.nl To: monetdb-users@lists.sourceforge.net Subject: Re: [MonetDB-users] Query time problem

Hi Chris,

with the Aug2009-SP1 release of MonetDB/XQuery on 64-bit Fedora 10 Linux, I cannot reproduce the problem:

$ mclient -t -lx -s'1+2' 3

Trans 3.090 msec Shred 0.000 msec Query 4.770 msec Print 0.383 msec

$ mclient -t -lx -s'1+2' 3

Trans 3.279 msec Shred 0.000 msec Query 4.734 msec Print 0.405 msec

$ mclient -t -lx -s'1+2' 3

Trans 3.093 msec Shred 0.000 msec Query 4.762 msec Print 0.389 msec

Hence, the questions are: - Which version of MonetDB are you running? (cf., e.g., `Mserver --version`) - What kind of queries are you running? - Does the actual query execution time increase (e.g., a performance degradation due to some internal server status), or does only the displayed time increase (e.g., because the internal counter/variable is not properly reset to 0)?

Stefan

On Fri, Oct 02, 2009 at 07:30:48PM +0300, Chris Baros wrote:

...

Hi

I am using Monetdb xquery in a Windows platform,

I want to measure the timing in some queries. But every time I run a query, I see that the "Query time" increases. If I restart the server, then again at the first time the Query time is normall, and by the second and after, increases again..

Do you have any ideas whats the problem?

_________________________________________________________________ Show them the way! Add maps and directions to your party invites. http://www.microsoft.com/windows/windowslive/products/events.aspx ------------------------------------------------------------------------------ Come build with us! The BlackBerry® 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/devconf _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users

-- | Dr. Stefan Manegold | mailto:Stefan.Manegold@cwi.nl | | CWI, P.O.Box 94079 | http://www.cwi.nl/~manegold/ | | 1090 GB Amsterdam | Tel.: +31 (20) 592-4212 | | The Netherlands | Fax : +31 (20) 592-4312 |

------------------------------------------------------------------------------ Come build with us! The BlackBerry® 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/devconf _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users

_________________________________________________________________ Windows Live: Make it easier for your friends to see what you’re up to on Facebook. http://www.microsoft.com/middleeast/windows/windowslive/see-it-in-action/soc...