Thank you，Stefan Manegold.I will try. I want to go to CWI to study database
.CWI is a very excellent research institutions.
Best regards!
2010/7/15 Stefan Manegold <[email protected]>
> 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
> > [email protected]
> > https://lists.sourceforge.net/lists/listinfo/monetdb-developers
>
>
> --
> | Dr. Stefan Manegold | mailto:[email protected] |
> | 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 |
>
------------------------------------------------------------------------------
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
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-developers
