Skip to content

Instantly share code, notes, and snippets.

@hanafiah

hanafiah/group.by.all.sql

Last active August 29, 2015 13:57
Show Gist options
  • Save hanafiah/9546320 to your computer and use it in GitHub Desktop.
Save hanafiah/9546320 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
group.by.all.sql
SELECT link_id,COUNT(*) FROM ltlinks_log WHERE MONTH(datalog) = '3' AND YEAR(datalog) = '2012' GROUP BY link_id;
/* 0 rows affected, 233 rows found. Duration for 1 query: 174.312 sec. */
SELECT link_id,COUNT(*) FROM ltlinks_log WHERE datalog BETWEEN '2012-03-01 00:00:00' AND '2012-04-01 00:00:00' GROUP BY link_id;
/* 0 rows affected, 233 rows found. Duration for 1 query: 173.172 sec. */
SELECT link_id,COUNT(*) FROM ltlinks_log WHERE MONTH(datalog) = '3' AND YEAR(datalog) = '2012' GROUP BY crc32(link_id);
/* 0 rows affected, 233 rows found. Duration for 1 query: 4.765 sec. */
SELECT link_id,COUNT(*) FROM ltlinks_log WHERE datalog BETWEEN '2012-03-01 00:00:00' AND '2012-04-01 00:00:00' GROUP BY crc32(link_id);
/* 0 rows affected, 233 rows found. Duration for 1 query: 4.625 sec. */
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment