[Monetdb-developers] [PF] Question about timings

Stefan Manegold Stefan.Manegold at cwi.nl
Tue Mar 25 09:25:28 CET 2008


On Tue, Mar 25, 2008 at 09:12:44AM +0100, Keulen, M. van (Maurice) wrote:
> Hi,
> 
> A student of mine is trying to speed up some queries and is puzzled 
> about the timing-readings he gets, for example:
> 
 Trans   19681.811 msec:	Query translation ("compilation") (server)
 Shred       0.000 msec:	Document shredding & loading (server)
 Query   16384.143 msec:	Query execution (server)
 Print      81.180 msec:	Result serialization (server)
 Timer   55087.438 msec:	Wallclock (client; all above + client-server communication)
> 
> The total of the first four 19.7+0+16.4+0.08 is approximately 36.2 
> seconds. "Timer" gives 55.1 seconds. Where are the remaining 18.9 
> seconds going?

(unless there is a bug somewhere:) "client-server communication" (cf.,
http://www.cwi.nl/htbin/ins1/publications?request=abstract&key=Ma:TR-CWI:07)

Which version of MonetDB/XQuery are we talking about?

> By the way, what do these measures precisely indicate? "Query", for 
> example, can be interpreted as query compilation or query execution.

See above.

Stefan

> Maurice.

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




More information about the developers-list mailing list