Thank you for quick reply. 
So, you mean the '-f none' option is not working??
and, when testing monetDB performance with tpc-h like benchmark, 
the performance is tested using 'cat file.sql |mclient -lsql -t -f raw |grep Timer' ?? 


Thanks so much.
Maria

Re: [MonetDB-users] monetdb output mode -f
From: Martin Kersten <Martin.Kersten@cw...> - 2009-03-25 19:58
Maria wrote:
> Hi, I would like to run query with out printing output in order to

> monitor its performance.
> I tried to use '-f none' in command-line, but it didn't work for
> monetdb5. (I am not using xquery here)

The way to avoid the timing in output rendering then you might consider
replacing your queries by count(*) queries. In all other cases, the data is
sent from server to mclient for rendering. If you use the mode 'raw' this

amounts to a plain dump without further rendering concerns.
The following might be what you want:

cat file.sql |mclient -lsql -t -f raw |grep Timer

>
> > ./mclient -lsql -uxman -ddemo -t -f none 1.sql

>
> ===> then, it prints all the results on the screen and display time.
>
> I want it only display time, not the query results.

> I also tried to redirect using /dev/null. In this case, it didn't
> display time.
>
> Isn't the '-f none' working in monetdb5?? If so, how can I measure the

> query time ?
>
> Thanks in advance.
> Maria.