… improve documentation), but finally I ended up with next load statement: /usr/local… AS c FROM ontime WHERE DepDelay>10 AND YearD=2007 GROUP BY carrier), t2 AS (… 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
…. There are benefits with both “scale-up” and “scale-out”, but once again, the “scale-out” results are the most striking. — Q4…_id) join dim_flight using(flight_id) WHERE DepDelay>10 AND Year=2007 GROUP BY Carrier ORDER BY c DESC; — Q5 SELECT…_id) join dim_flight using(flight_id) WHERE DepDelay>10 AND Year=2007 GROUP BY Carrier) t JOIN (SELECT Carrier, count(*) AS…
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 … LIMIT 10; Q4 – SELECT carrier, count(*) FROM ontime WHERE DepDelay>10 AND FlightDate between ‘2007-01-01′ and ‘2007-12-31… queries though, and I’ll post a follow-up when I do. — Full Disclosure — This is a…
Post: PBXT benchmarks
April 8, 2007 By 14 Comments
… MyISAM vs Falcon (http://www.mysqlperformanceblog.com/2007/01/08/innodb-vs-myisam-vs-falcon… TABLE IF NOT EXISTS `$tableName` ( `id` int(10) unsigned NOT NULL auto_increment, `name` varchar(…up run (duration 180 sec), and then run three effective runs (duration of each is 60 sec). As the final result…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
…algorithms used for read ahead and results were significant. They however were not… Yasufumi Kinoshita talked at Users’ Conference 2007 about his patch that makes InnoDB…to do 1 write than flush 10 non sequential pages from it which … Yasufumi Kinoshita attained very nice scaling up to 8 or 16 cores. …
