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:[EMAIL PROTECTED] |
| 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 |
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Monetdb-developers mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-developers
