Multilingual website extremely slow
vincentc - February 25, 2007 - 18:46
| Project: | Internationalization |
| Version: | 4.7.x-1.0 |
| Component: | Miscellaneous |
| Category: | support request |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | closed |
Jump to:
Description
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
#1
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.
#2
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
#3
its particularly slow while accessing a multilingual view? as in, if someone toggles to 'spanish' while browsing an english view. its slow regardless though
#4
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'
#5
ok disabling the 'location' module (an add-on) fixed the problem
#6
I guess I close it then, unless you want to post a bug for some other module.