Thanks for the link and the explication. In fact I'm running the query normally first (without the time option) and I get about 600ms at the end of the execution.
Then when I use time mclient -d db query.sql/dev/null
that gives me real 1m3.895suser 0m15.640ssys 0m2.160s
So it's not really the issu of cold and hot data because for the first normal execution I got a time much more smaller than the second one using Time.
I really appriciate your help because I need to get the exact real execution time.
One more question please what is the meaning of real, user and sys or where I can find the difinition of these parameters.
Thanks again
Date: Sun, 13 Oct 2013 14:36:16 +0200
From: martin@monetdb.org
To: users-list@monetdb.org
Subject: Re: Query execution time
perhaps this might help
http://www.monetdb.org/Documentation/Cookbooks/SQLrecipes/QueryTiming
On 10/13/13 12:31 PM, baraa Mohamad wrote:
That's great! Thank you very much for your appreciated help.
I just could't really understand the output of this command.
This is my output:
Real: 1m23
User: 0m24s
Sys: 0m2.3s
I'm a little bit confused because when I execute the same
query directly without the time option i get 733,28ms.
So i couldn't know what is the real execution time.
Le 13 oct. 2013 à 11:29, "Martin Kersten"
a écrit :
How about (time mclient -d db <inputfile
>/dev/null)
On 10/13/13 11:24 AM, baraa Mohamad wrote:
Thank you for your answer.
But in general I would like to
know how to get the query exexution time
without printing the results.
It's for performance comparaison. I want
to evaluate MonetDB for my
research and i'm working with large tables.
Please any idea??
Greetings,
Baraa
Le 13 oct. 2013 à 11:02, "Martin
Kersten" mailto:Martin.Kersten@cwi.nl>
a écrit :
Hi
On 10/13/13 10:55 AM, baraa
Mohamad wrote:
Hello dear MontDB users,
I have a question
please, I just need to get the query execution
time
without showing the
results of the query (for performance
comparaison) .
Something which
corresponds to the "traceonly" in Oracle. that
will be
greate if I can see the
query plan but for the moment the most
important
for me is to get the
query execution time.
for example: I want to
know the query exection time of this query
(select * from source
where a>10) knowing that I have more than one
This is not the ind of query
you fire when you expect a large outcome.
Better use SELECT COUNT(*)....
hundred million records
which correspond to this predicate.
Thank in advace for your
appreciated help.
Baraa
_______________________________________________
users-list mailing list
users-list@monetdb.org
mailto:users-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/users-list
_______________________________________________
users-list mailing list
users-list@monetdb.org
mailto:users-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/users-list
_______________________________________________
users-list mailing list
users-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/users-list
_______________________________________________
users-list mailing list
users-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/users-list
_______________________________________________
users-list mailing list
users-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/users-list
_______________________________________________
users-list mailing list
users-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/users-list
