Hello,

I've built a multilingual website with i18n, which is great, but the website is extremely slow especially when you switch from one language to another: the "devel" module indicates that page execution time may reach 200 seconds (200.000 ms!) for one single page to run (the most time-consuming queries coming from the locale module).

It seems that the site behaves as if the cache didn't exist (although it is turned on) and recalculates everything at every new request. Any idea why? Could it come from an interaction with other modules I have installed? Would upgrading to Drupal 5 (and its new handling of the cache) improve things?

Thank you,
Vincent

Comments

jose reyero’s picture

jose reyero commented
Category: bug » support

It may be any other module using t() in the init_hook. Also, if you don't have the strings translated, a query will be used for each string.

So please make sure it is i18n module causing the trouble and not any other module or only locale.

drupalxykon’s picture

drupalxykon commented

I have the same problem and I don't have any add-on modules apart from views..the strings are translated completely. there seem to be a whole bunch of locale queries which are slow

drupalxykon’s picture

drupalxykon commented

its particularly slow while accessing a multilingual view? as in, if someone toggles to 'spanish' while browsing an english view. its slow regardless though

drupalxykon’s picture

drupalxykon commented

example slow query :

1099.09 0 locale SELECT s.lid, t.translation FROM locales_source s INNER JOIN locales_target t ON s.lid = t.lid WHERE s.source = 'logs' AND t.locale = 'es'

drupalxykon’s picture

drupalxykon commented

ok disabling the 'location' module (an add-on) fixed the problem

jose reyero’s picture

jose reyero commented
Status: Active » Closed (fixed)

I guess I close it then, unless you want to post a bug for some other module.

bestmvpatel’s picture

bestmvpatel commented
Issue summary: View changes

Hi I am getting same issue with Locale Module,
UK website is giving page in just 1.86 sec but dutch website or other link is getting more than 10 second to reload the page,
Anyone can help me please?