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