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 |

Really？is *Jun2010* release？Thanks Best regards 2010/7/16 Fabian Groffen

On 16-07-2010 10:44:40 +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 the latest version of the current development sources of MonetDB, mclient prints execution time (without the costs of printing to the screen) of select and update queries. Maybe that is what you're looking for?

...

In monetdb homepape,i see your benchmarks,and I want to know how did you test the time?

------------------------------------------------------------------------------ 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

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 写道：

...

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 |

-- | 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 |