title: If threads are getting 3000 posts each is it maybe better to make a new table per thread?
body: <p>There's 12 million posts already and people seem to be using things as a chat. I don't know if it's more efficient to have a bunch of little tables than having the database scan for the last 10 messages in a database with so many entries. I know I'd have to benchmark but just asking if anyone has any observations or anecdotes if they've ever had similar situations.</p>
  
  <p>edit add schema:</p>
  
  <pre><code>create table reply(
  id int(11) unsigned not null  auto_increment,
  thread_id int(10) unsigned not null default 0,
  ownerId int(9) unsigned not null default 0,
  ownerName varchar(20),
  profileId int(9) unsigned,
  profileName varchar(50),
  creationDate dateTime,
  ip int unsigned,
  pic varchar(255) default '',
  reply text,
  index(thread_id),
  primary key(id)) TYPE=MyISAM; 
  </code></pre>