On Thu, Jul 15, 2010 at 04:45:25PM +0800, kun ren wrote:
> Dear everyone,
>    Recently,i am testing the performance of MonetDB. But I want to know the
> time of execution one sql. I type  \t on CLI. and then it returns a
> execution time. But I found that the time include the print resultset time.I
> just only want to know the time of execution ,not include the print time. So
> please tell me what do i do?

If "print time" refers to actually echoing the result to a terminal,
then simply redirect your output to a file (or even /de/null, after you
have verified thet your query indeed produced the correct output),
either by using "\>" in mclient, or by redirecting alll mclient output using
">" in the command line.

If "print time" (also) refers to serialization of the result table,
then store the result into a table, e.g.,

       create table result as ( <your query> ) with data;

If "print time" (also) refers ot actual materialization of the result table,
then only get the size (rowcount) of the result table, e.g.,

       select count(*) from ( <your query> ) as result;

Hope this helps you further.

Stefan

> -----------------Best regards!

> ------------------------------------------------------------------------------
> This SF.net email is sponsored by Sprint
> What will you do first with EVO, the first 4G phone?
> Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first

> _______________________________________________

> Monetdb-developers mailing list
> Monetdb-developers@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/monetdb-developers

--
| Dr. Stefan Manegold | mailto:Stefan.Manegold@cwi.nl |
| CWI,  P.O.Box 94079 | http://www.cwi.nl/~manegold/  |
| 1090 GB Amsterdam   | Tel.: +31 (20) 592-4212       |
| The Netherlands     | Fax : +31 (20) 592-4199       |