I want to create a MyISAM
log table with Unix timestamp values. I will have various SELECT
statements every once in while using a "from" date to "to" date and the table will grow quite large.
I don't know which would be the fastest between an Indexed INT or Indexed TIMESTAMP
(they have the same storage space I believe).
I checked on Stackoverflow already but the answers are somewhat vague, from new members or they say one or the other.
It shouldn't make a difference. Timestamps are represented internally as integers, so comparing and indexing them will be essentially the same.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With