MySQL Forums
Forum List  »  Database Administration & Monitoring

Advanced Search
New Topic

Re: size concers
Posted by: Peter Brawley
Date: August 29, 2014 09:46AM

6 million rows/year isn't very big, will perform well if correctly designed.

`startDate` int(50) NOT NULL, `endDate` int(50) DEFAULT NULL look like nonsense. If they're dates, make them date columns.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
size concers
Dimitris Papageorgiou
August 29, 2014 09:28AM
Re: size concers
Peter Brawley
August 29, 2014 09:46AM
Re: size concers
Dimitris Papageorgiou
August 29, 2014 12:40PM
Re: size concers
Peter Brawley
August 29, 2014 04:31PM
Re: size concers
Dimitris Papageorgiou
August 31, 2014 08:25AM
Re: size concers
Rick James
August 31, 2014 06:06PM
Re: size concers
Dimitris Papageorgiou
September 01, 2014 02:29AM
Re: size concers
Padmanabhaiah Akurathi
September 19, 2014 12:48AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.