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" <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>

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