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.