… developers improve documentation), but finally I ended up with next load statement: /usr/local/… query for wide range of years 2000-2008: Result is: [ "EV", 443798, 1621140, 273 ] [ "AS", ... 1885942, 7915940, 238 ] [ "FL", 287815, 1220663, 235 ] … And execution 12.5s MonetDB and 21.83s InfoBright. (…
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….JOIN dim_flight using (flight_id) WHERE Year BETWEEN 2000 and 2003 AND Carrier = ‘AA’ GROUP BY Year,…
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 most…(*) AS c FROM ontime WHERE FlightDate BETWEEN ‘2000-01-01′ AND ’2008-12-31′ GROUP BY DayOfWeek ORDER BY c…those queries though, and I’ll post a follow-up when I do. — Full Disclosure — This is a text…
Comment: Full text search for all MySQL Storage Engines
June 28, 2006 By 37 Comments
…this has been limited down to 100bit (12.5 bytes) which also can be…to regular reversed index which might end up with 500.000 items of each … vectors for the processing). Some benchmark results which I have collected on my … cheating (limit each word internally to 2000 hits): 1.66 seconds Sphinx: 16….
Post: Intel SSD 910 vs HDD RAID in tpcc-mysql benchmark
September 11, 2012 By 6 Comments
…RAID over 2x200GB devices) Filesystem: ext4 Software OS: Ubuntu 12.04.1 MySQL Version: Percona Server 5.5….HDD RAID, but the result is taken only for last 1h to remove warm-up phase Parameters to vary: … In conclusion I see that for its price (around $2000 on date of publishing) Intel SSD 910 handles …
