Sunday, 11 August 2013

MYSQL large data table setup

MYSQL large data table setup

I have a table that looks like the following:
CREATE TABLE IF NOT EXISTS `levels` (
`id` int(6) NOT NULL AUTO_INCREMENT,
`name` varchar(25) NOT NULL,
`creator` varchar(25) NOT NULL,
`levelcode` longtext NOT NULL,
`description` mediumtext NOT NULL,
`date` date NOT NULL,
`views` int(6) NOT NULL,
`favCount` int(6) NOT NULL,
`total_votes` int(11) NOT NULL,
`total_value` int(11) NOT NULL,
`rating` float(4,2) NOT NULL,
`spamCount` int(3) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
Basicly I have created a game where people can submit their own levels.
What I am currently debating is whether or not to move the levelcode
column into its own table, or even each level in its own textfile.
Levelcode can get fairly large(500,000+ characters)
have any advice?

No comments:

Post a Comment