Remove unnecessary query in my G2

tombatore

Joined: 2006-07-23
Posts: 34
Posted: Sun, 2010-10-10 19:01

All,

I'm running G2 in embedded mode on an English site. I have set English to default in the admin and switched off the "auto detect language from browser" feature. Hence gallery MUST always run in English.

However, the following query keeps popping up in my database server:
UPDATE g2_PluginParameterMap SET g_parameterValue='en' WHERE g_pluginType='module' AND g_pluginId='core' AND g_itemId=0 AND g_parameterName='default.language';

Because I need to reduce DB load as much as I can, can someone point me to the code where this query is executed, or a configuration possibility to disable this and ALWAYS use english at any time?

Thank you,
Steven

 
gaurav10feb

Joined: 2010-08-24
Posts: 31
Posted: Wed, 2010-11-17 00:31

Hello Tombatore, i m tryin to do the same but no luck so far...there are so many queries which we dont need but making site very slow and big load on mysql server. Please someone help

 
tombatore

Joined: 2006-07-23
Posts: 34
Posted: Wed, 2010-11-17 22:26

With me the query was actually in the embedding code, so in the end it was me who had to improve performance of the embedding into my website.

On the other hand, I am continuously looking for ways to speed up gallery2, there are lots of thing that I don't need which slow it down, like permission stuff. I looking into G3, but not being able to not have watermarks in thumbnails is a stopper for me.