Download & Extend
Memcache API and Integration » Issues

A lot of locale_source queries. Looks patch of locales files is bad

Posted by Brumisek on November 8, 2009 at 4:42pm
Project:Memcache API and Integration
Version:5.x-1.9
Component:Code
Category:bug report
Priority:critical
Assigned:Brumisek
Status:closed (cannot reproduce)

Issue Summary

Hi all, I already run memcache module, because my site is realy huge. Thanks for this amazing module.
However, I have to use memcache.db.inc file, because when I use memcache.inc (no db writing) then I have hundred of queries of this type on every page:

SELECT s.lid, t.translation FROM locales_source s INNER JOIN locales_target t ON s.lid = t.lid WHERE s.source = 'Line break converter' AND t.locale = 'cs'

locale SELECT s.lid, t.translation FROM locales_source s INNER JOIN locales_target t ON s.lid = t.lid WHERE s.source = 'Manage Invite settings' AND t.locale = 'cs'

locale SELECT s.lid, t.translation FROM locales_source s INNER JOIN locales_target t ON s.lid = t.lid WHERE s.source = 'RSS feed' AND t.locale = 'cs'

locale SELECT s.lid, t.translation FROM locales_source s INNER JOIN locales_target t ON s.lid = t.lid WHERE s.source = 'profile' AND t.locale = 'cs'

locale SELECT s.lid, t.translation FROM locales_source s INNER JOIN locales_target t ON s.lid = t.lid WHERE s.source = 'HTML E-mail settings' AND t.locale = 'cs'

locale SELECT s.lid, t.translation FROM locales_source s INNER JOIN locales_target t ON s.lid = t.lid WHERE s.source = 'Subscriptions' AND t.locale = 'cs'

... etc etc (looking for translation).

My idea is the patch of locale files (there are two files) is bad and locale function is not working well. There is not right storing of locale_sources in memcache so system have to look for the translation into the locales_source (cache is disabled by memcache.inc file so no looking to cache table what is quicker fo course).

My drupal version is: 5.6 (i used 5.6 patch of course).

Thank you all for any help, I'm using now memcache.db.inc and works in fact OK, but memcache.inc would be much better solution (bigger performance). I can't run it because of this hundred of calls :(

Login or register to post comments

Comments

#1

Posted by catch on February 4, 2011 at 8:39am
Status:active» closed (cannot reproduce)

Since this issue is 18 months old I'm closing it out. If you're still running into it, please update. Seems possible that your locales cache was more than 1mb so couldn't be written to memcache.