On 12 October 2014 02:32, Yongbiao Long <longyongb...@gmail.com> wrote: > 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.
Are you sure your basic design is appropriate? Having 100,000 associated records per user seems very high. Are you able to explain what is in those records in case an alternative can be suggested? Colin -- 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/CAL%3D0gLs_XsU3fHhomae%3DnM9tiicm%3DRfAiYh0sUXizb6Nb7L14g%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
