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.n...@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.maneg...@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@lists.sourceforge.net > >> > https://lists.sourceforge.net/lists/listinfo/monetdb-developers > >> > >> > >> -- > >> | Dr. Stefan Manegold | mailto:stefan.maneg...@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.maneg...@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 | ------------------------------------------------------------------------------ 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
