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?
在 2010年7月15日 下午9:30，kun ren
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
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 |