[Monetdb-developers] [PF] Question about timings
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:
> 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.,
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.
| 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