Continuous locale query?

[WEBmods]

Hello,

Does anyone know if it's normal for these two locale queries to run very frequently (they keep running one after other in queries.log):

Code: [Select]

SELECT pk_c_code, s_name, s_short_name, s_description, s_version, s_author_name, s_author_url, s_currency_format, s_dec_point, s_thousands_sep, i_num_dec, s_date_format, s_stop_words, b_enabled, b_enabled_bo
FROM (gsti_t_locale)
WHERE pk_c_code = 'en_US'

----

SELECT *
FROM (gsti_t_locale)
WHERE b_enabled = 1
ORDER BY s_name ASC

I think it's overflowing the database... I know I can try to disable plugins and themes to check but I want an opinion on this first.

Thanks, regards.

[dev101]

When it comes to SQL, there are things that may affect them like query cache and query optimizer, both are within SQL itself and unless you see very long query times, I wouldn't worry too much about them. But, as you said, find out first what generates them and from there you might see what optimization you can achieve, without breaking anything.

[WEBmods]

The thing is that I (actually my friend) get "MySQL server has gone away" errors and oc-admin is very slow. I checked queries.log and I saw that 2 queries repeating so I thought they are the reason.

I will try to find where are they called.

Thanks, regards.

[dev101]

t_locale is small, and since the data rarely changes, it should be really fast. 2nd query seems standard, 1st one is something custom probably. Each requests populates languages for various reasons, so 1/page/req is normal.

Can be many things, cron, plugin, or sometimes some users report this.

[WEBmods]

I think https://github.com/osclass/Osclass/issues/2297 did it. I told the friend to do more tests, but from what I've seen oc-admin is much quicker currently.

Thanks a lot. Regards.