… wish developers improve documentation), but finally I ended up with next load statement: /usr/local/monetdb/… Both InforBritgh and MonetDB executes it immediately with result 117023290 rows Now some random queries I…4y, 37.57s, 2.12s 10y, 79.77s, 29.14s UPDATE (5-Oct-2009): James Birchall recommended…
Post: Gathering queries from a server with Maatkit and tcpdump
July 1, 2009 By 23 Comments
…profile here to illustrate that you can get really compact results to see what’s going on inside your server. …33ms 737us # Hosts 8 # Time range 2009-07-01 23:55:41.334082 to 2009-07-01 23:56:33.929945 # … Look at the top of the report — what is up with the 12% of queries that say No_index_used? If …
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…. dim_flight using (flight_id) WHERE Year BETWEEN 2009 and 2011 GROUP BY Carrier,dest.CityName ORDER…
