Speeding up international Drupal versions
Would you like your non-english Drupal site to be more responsive ? I just found two-minute hack to speed it up, by a factor of four on the new Riff hosting. Here's how.
While revising devel.module in order to update the french translation, I noticed the queries performed by locale() took on the order of 20ms to be performed, and there are a whole lot of them on most pages when locale.module
is enabled.
Since this seemed abnormally slow, I looked at the structure, and saw why. The current MySQL code goes: