About compilation time
E.Rozenberg at cwi.nl
Thu Dec 10 18:09:48 CET 2015
On 09-12-15 08:54, Stefan Manegold wrote:
>> In addition, looking at the results, compile time is order of tens of ms. Is
>> this what I should expect?
> Sound reasonable to me.
An additional note from my experience...
Mustafa, I would guess you're configuring all of the DBMSes in your
comparison to utilize the CPU as much as possible, right? With MonetDB,
that would specifically mean setting your DB's nthreads value to match
what your hardware supports. So, in my experience the compilation time
changes, often significantly, for different values of nthreads.
In my old group at Hua Wei research, we actually added timing hooks for
measurement, and a few of these are visible here:
bottom-right chart (note all columns are normalized to 100%; the
brownish-dark-red blocks at the bottom are MonetDB's query
comiplation/optimization, with all columns named 'AXE' being nthread=1
for reasons I won't go into). We observed a ratio of over 2:1 between
32-thread and single-thread query compilation. We also observed some
non-negligible variance in timing.
Caveat: This was with a version of MonetDB from 2013, so things may have
More information about the developers-list