Redirecting the output to /dev/null can be an option:

sql>\>/dev/null

sql>select * from tables;

94 tuples (1.883ms)

sql>

In general, I would not use LIMIT in your queries for this purpose, as it could in some cases optimise your query.

If you are interested in seeing where the time goes within a query, them use TRACE SELECT .. (not suited for measuring wall-clock times as it adds overhead).

Roberto

On 10 September 2014 06:02, Bing Zhang <bingzhan@buffalo.edu> wrote:

hi:

I am trying to measure query performance of monetdb, but not sure about the time output by using option -ims includes the query results printing time, or it is just the query time.

Is there some way to silence the output of queries?

Thanks.

_______________________________________________
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