…WHERE hash=crc32(‘string’) AND string=’string’ The other thing you need to consider is string comparison in MySQL…date ranges? or between dates? or after a date? A: Date comparisons work very similar to other comparison…
Post: A case for MariaDB's Hash Joins
May 31, 2012 By Leave a Comment
…DEFAULT NULL, `l_shipDATE` date DEFAULT NULL, `l_commitDATE` date DEFAULT NULL, `l_receiptDATE` date DEFAULT NULL, `l…WHERE clause The SQL used for this test together with its EXPLAIN output as returned by MySQL… the right-side table becomes costly in comparison. Block Nested Loop Join would perform …
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 20 Comments
…where. You may not use sub-queries or any non-deterministic functions like NOW() or RAND(). HAVING clauses, ORDER BY clauses…in response time. Refresh method performance comparison For demonstration purposes, I did the… are out-of-date and must be refreshed: mysql> select sum(total_lines) from …
Post: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 8, 2007 By 117 Comments
… performs in comparison to InnoDB and…64) NOT NULL default ”, `dob` date default NULL, `address` varchar(128…MySQL 5.1.14-beta sources for MyISAM / InnoDB and MySQL 5.1.14-falcon bitkeeper tree bk://mysql.bkbits.net/mysql…WHERE country_id = %d LIMIT 5 The same query as previous but with LIMIT clause…
