Marcus Ob
2006-Feb-10 23:33 UTC
[Rails] Solution for multilanguage caption lookup speed improvement?
Hello. In my Rails app i have a helper method called "translate": def translate(name) tran = Translation.find_by_name(name) ... ... end As you can see, the method does a lookup in the table "Translation", where i have an index in the field "name". This is working well, but in a single page i can have dozens of captions to translate, and there are several concurrent users, so the whole thing slows a bit. I guess preloading the Translation table in a Hashtable would help, but i wouldn''t load this hash table in each user session: how can i use a single Hashtable per Server instance ? Also, with many users i -randomly- have a "MySQL lost connection error".I guess finding a solution for the lookup could avoid having this problem. Thanks, Marcus. -- Posted via http://www.ruby-forum.com/.