Sumeet Panchal wrote: > Hi, > > I have a relational database (MySQL) with 200 tables in it. Now I want > to reduce number of tables (If it helps in improving the > application).
Why? There's nothing wrong with having 200 tables if they're necessary to model your data properly. On the other hand, 200 is a high number, and you could probably stand some normalization or something. > > One approach is to use EAV database model. [...] And it's a *very* bad approach. Don't do this unless there is no other way to model your data sensibly. If you can say more about your schema, perhaps we can offer better suggestions. Best, -- Marnen Laibow-Koser http://www.marnen.org [email protected] -- Posted via http://www.ruby-forum.com/. -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
