rubyonrailsin

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
marnen@marnen.org
--
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 rubyonrails-talk@googlegroups.com.
To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.