Casting date strings to datetime before comparison using BETWEEN

npm / download-counts

Background jobs and a minimal service for collecting and delivering download counts

329 stars 27 forks source link

Closed seldo closed 9 years ago

seldo commented 9 years ago

According to http://dev.mysql.com/doc/refman/5.0/en/comparison-operators.html#operator_between using CAST and BETWEEN will be faster but so far EXPLAIN is showing no difference. Doesn't hurt, though.

seldo commented 9 years ago

(This is running on downloads-3-west as a test)

othiym23 commented 9 years ago

Aside from in-air conversation, this looks like the conventional approach. LGTM. :flags: