Today I had a hard fight for performance of a Drupal 7 multilingual website. Using the devel.module I analyzed several MySQL InnoDB requests on each payload and their performance. A thing that popped up again and again was the locales_source table. The translation queries were not big, but they were many. ;) And they summed up.