Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

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.

Thanks,

Kyle

share|improve this question
1  
Any idea how many campaigns they may be? 5K records of your row size won't amount to a large amount(MB) of data. Your biggest concern will likely be having appropriate indexes when you go to query the data. –  Jeff Hengesbach Jun 4 '10 at 15:24
1  
I will second the comment from Jeff - I actually created a table last week which gets about 30 inserts every 5 minutes. When I checked earlier it had ~60k records in it - that was taking 4.5MB (as reported by phpmyadmin). It is just on my (average) desktop and has no real indexes, and still queries pretty quickly. YMMV of course though :) –  Ben Pilbrow Jun 4 '10 at 18:46

2 Answers 2

up vote 0 down vote accepted

If the table is really growing fast (and very big) you could look at partitioning:

http://dev.mysql.com/tech-resources/articles/performance-partitioning.html

share|improve this answer
    
Pier, I will look at this later on. TY –  Kyle Hudson Jun 6 '10 at 11:12

Unless you're talking a million records a day, I'm not at all worried about data growth, assuming it's running on contemporary hardware and not a PIII-800mhz.

share|improve this answer
    
darthcoder: to start with we are estimating 20k records per day, but we know this amount will jump the further we get. –  Kyle Hudson Jun 6 '10 at 11:12

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.