Re: Query execution time

13 Oct 2013

      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