Re: Query execution time

The first time you run a query all your data may reside on disk, i.e. a cold database. The second time you run the same query you benefit from caching effects, i.e. a hot database 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" mailto:Martin.Kersten@cwi.nl> 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 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 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 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 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