sql - Is it practical to normalize timestamps in MYSQL? -


if have click data on server expects more 1 click per second, practical normalize timestamps?

basically, this:

create table clicks( id int(6) unsigned auto_increment primary key, timestamp timestamp null ) 

vs

create table clicks( id int(6) unsigned auto_increment primary key, timestamp_id int(6) unsigned null ) create table timestamps( id int(6) unsigned auto_increment primary key, timestamp timestamp  null ) 

no, not @ all. time split stuff out table if there piece of data associated want save itself. not case here, , timestamp not going reused.


Comments

Popular posts from this blog

javascript - Using jquery append to add option values into a select element not working -

Android soft keyboard reverts to default keyboard on orientation change -

jquery - javascript onscroll fade same class but with different div -