We are creating a table to store reponses from customers marketing campaigns, each campaign can generate circa 5k records.
With a fast growing customer base we are concerned this table will become too big to retrieve filtered resultsets.
The table type is MyISAM and the row format is dynamic, it has a PK, AI on the record ID.
Table Structure is:
CREATE TABLE `tbl_campaignsSent` ( `cid` int(9) NOT NULL auto_increment, `name` varchar(100) default NULL, `uid` int(9) default NULL, `totalSent` varchar(9) default NULL, `dt` datetime default NULL, `mesageContent` varchar(300) default NULL, `sentToTwitter` enum('0','1') default '0', PRIMARY KEY (`cid`) ) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
Any help would be appriciated.