Hi, everyone, I've learned Rails(Web development) on my own for two months, and came to a situation like this:
There are two tables A and B in my database. A 'has_many` B. For every user input, There is an entry in table A. At the same time, I need to add a huge number(say 100,000) of entries in B. As table A grows, table B seems to grow uncontrollably. There must be performance issues in later data manipulation operations, or even 'overflow` problems. I use Mysql. My initial thought was to split table B, for example, for every entry in table A, create a new table (on the fly) for it. The questions are: Is my thought right? If yes, then how to design the models and migrations to represent the relationship correctly? If not, what are good practices to solve this kind of problem? I'd be very grateful if you could only give some hints, doc or good articles about it. -- Best Regards -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To unsubscribe from this group and stop receiving emails from it, send an email to rubyonrails-talk+unsubscr...@googlegroups.com. To post to this group, send email to rubyonrails-talk@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/rubyonrails-talk/CALDAArrsvWhbQ-VXkx-Xj2B16zJbC%2Bg%2BcQpy_S68vO4sJCJG4g%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
