Maria wrote:

Thank you for quick reply. So, you mean the '-f none' option is not working??

mclient --help -f kind | --format=kind specify output format {xml,typed,dm} for XQuery, or {csv,tab,raw,sql,xml} These are the rendering formats supported

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

------------------------------------------------------------------------

------------------------------------------------------------------------------

------------------------------------------------------------------------

_______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users