[Monetdb-developers] TPC-H benchmark about MonetDB

Stefan Manegold Stefan.Manegold at cwi.nl
Fri Jul 16 09:06:48 CEST 2010


On Fri, Jul 16, 2010 at 10:44:40AM +0800, kun ren wrote:
> I have try the redirecting  ,but it also have more time,and contain the
> write file time.I just only want to know the time of actual execution
> time.what do i do?
> In monetdb homepape,i see your benchmarks,and I want to know how did you
> test the time?

The times under http://monetdb.cwi.nl/SQL/Benchmark/TPCH/index.html do
include result creation (output redirected to file as we indeed do  not want
to measure the terminal's scrolling speed). The tie were measured using
mclient's timing option ("-t" / "\t").

Stefan

> 在 2010年7月15日 下午9:30,kun ren <renkun.nwpu at gmail.com>写道:
> 
> > 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 <Stefan.Manegold at cwi.nl>
> >
> >   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 at lists.sourceforge.net
> >> > https://lists.sourceforge.net/lists/listinfo/monetdb-developers
> >>
> >>
> >> --
> >> | Dr. Stefan Manegold | mailto:Stefan.Manegold at 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       |
> >>
> >
> >

-- 
| Dr. Stefan Manegold | mailto:Stefan.Manegold at 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       |




More information about the developers-list mailing list