…improve documentation), but finally I ended up with next load statement: /usr… 7915940, 238 ] [ "FL", 287815, 1220663, 235 ] … And execution 12.5s MonetDB and 21.83s …2007 | 7455458 | | 2008 | 7009728 | +——+———+ And execution time: MonetDB: 6.3s and InfoBright: 0.31s To group all results…
Post: Shard-Query turbo charges Infobright community edition (ICE)
May 6, 2011 By 23 Comments
… 8401 min(FlightDate): 1988-01-01 max(FlightDate): 2010-12-31 1 row in set (0.00 sec)…are benefits with both “scale-up” and “scale-out”, but once again, the “scale-out” results are the most striking…. using(flight_id) WHERE DepDelay>10 AND Year=2007 GROUP BY Carrier) t JOIN (SELECT Carrier, count(*)…
Post: Shard-Query adds parallelism to queries
November 15, 2010 By 18 Comments
… runs the SQL via ShardQuery and it prints the results. Test #1 This set of queries tests the … ontime WHERE DepDelay>10 AND FlightDate between ‘2007-01-01′ and ‘2007-12-31′ GROUP BY carrier ORDER BY 2 DESC; …those queries though, and I’ll post a follow-up when I do. — Full Disclosure — This is a …
