…competition_id, nothing more. Would doing a SELECT competition_id, COUNT(user_id) AS user_count FROM user_competition_entry GROUP BY competition…there any special concerns or tricks for selecting using some date ranges? or between dates? or after a date? A: Date comparisons work very similar to other…
Post: Shard-Query turbo charges Infobright community edition (ICE)
May 6, 2011 By 23 Comments
… query. . Query details: — Q1 SELECT DayOfWeek, count(*) AS c from ontime_fact JOIN dim_date using (date_id) WHERE Year BETWEEN 2000 AND 2008 GROUP… following queries depends on the size of the date range: — Q8.0 SELECT dest.CityName, COUNT( DISTINCT origin.CityName) from ontime_fact JOIN dim…
Post: Analyzing air traffic performance with InfoBright and MonetDB
October 2, 2009 By 50 Comments
…(4) DEFAULT NULL, `FlightDate` date DEFAULT NULL, `UniqueCarrier` char… benchmarker is SELECT count(*) FROM ontime;….count of direct connected cities for different diapason of years. SELECT DestCityName, COUNT( DISTINCT OriginCityName) FROM ontime WHERE Year BETWEEN… Q8 (1year range) traditional …
Post: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 8, 2007 By 117 Comments
…) NOT NULL default ”, `password` varchar(64) NOT NULL default ”, `dob` date default NULL, `address` varchar(128) NOT NULL default ”, `city` varchar….64 – 3.85 times. READ_PK_RANGE_INDEX Query: SELECT count(id) FROM $tableName WHERE id between %d and %d MyISAM scales good here…
Post: PBXT benchmarks
April 8, 2007 By 14 Comments
…) NOT NULL default ”, `password` varchar(64) NOT NULL default ”, `dob` date default NULL, `address` varchar(128) NOT NULL default ”, `city` varchar…_RANGE_INDEX Query: SELECT count(id) FROM $tableName WHERE id between %d and %d The same comment as for previous query. READ_KEY_RANGE Query: SELECT…
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
… sequential, by having a buffer in between where secondary key tuples are buffered …, and do a range primary key lookup as follows: SELECT non_key_column from … >= ’1993-08-01′ and o_orderdate < date_add( ’1993-08-01′ ,interval ’3′ … 5.5. Handler_mrr_rowid_refills counts how many times the buffer used …
Post: How (not) to find unused indexes
October 16, 2009 By 2 Comments
…SELECT count(*) FROM Country; +———-+ | count(*) | +———-+ |     239 | +———-+ 1 row in set (0.00 sec) mysql> SELECT count(distinct(population)) FROM Country; +—————————–+ | count… SIMPLE     | country | range | Population   |… a BETWEEN on a date, but…
Post: Using index for ORDER BY vs restricting number of rows.
February 16, 2007 By 8 Comments
… such as seller, price, date added etc. Such configuration …selective it is likely it will need to scan less than 100 rows to generate result. The speed difference between… into account column selectivity together with LIMIT range. If there …may have however is calculating count of matching rows which …
Post: Using any general purpose computer as a special purpose SIMD computer
May 16, 2011 By 5 Comments
…range operation over a set of integers or dates can be transformed into one or more discrete sub-ranges… `count(*)`=`count(*)` + VALUES(`count(*)`) Now, consider the query with BETWEEN…select min(result) == 0 is_prime from ( select mod({$NUMBER_TO_FACTOR}/prime_number) from dataset where id between…
