Well folks let me try to explain my problem. I have a database of musics and each music can have multiple artists through other table/model in the case Performers. I would like to record music in new/edit add artists and select them via a combo-box, used a simple collection_select, and used to add a new one a UJS i see on Railscasts. In the testing phase with few records everything was fine, but I have a legacy database table where the artists have 62k records. Well .. sure takes 18s to execute the query and render the page. and if I try to add a new artist with javascript app dies. I tried to use fragment caching to the select this did not work. I also tried using memcached, it is limited to 1M, and my query takes 5M, removed this limit and yet the system continues crashing when I add the javascript. my knowledge (almost none) to prevent me from creating javascript Another method of adding artists. I do not know if there is a way to improve performance through caching or whether it is design problem. The environment is: Ruby 1.9.3, Rails 2.3.3, MySQL 5.5 if someone could understand my problem and it is with great humor can look at this code snippet https://gist.github.com/2637961 Since already thank you very much.
-- 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+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
