
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.

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

thanks Roberto, it silences the output. And I found the query time output from mclient -ims, almost the same as before. On Wed, Sep 10, 2014 at 3:04 AM, Roberto Cornacchia < roberto.cornacchia@gmail.com> wrote:
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
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
participants (2)
-
Bing Zhang
-
Roberto Cornacchia