title: EAV Database Scheme
body: <p>I have a db with more that 100K records. 
  A lot of categories and many items (with different properties per category)
  Everything is stored in a EAV.</p>
  
  <p>If I try to break this scheme and create for any category a unique table
  is something that will I have to avoid?</p>
  
  <p>Yes, I know that probably I'll have a lot of tables and I'll need to ALTER them
  if I want to add an extra field, BUT is this so wrong?</p>
  
  <p>I have also read that as many tables I have, the db will be populate with more files
  and this isn't good for any filesystem.</p>
  
  <p>Any suggestion?</p>