Welcome Guest, Not a member yet? Register   Sign In
Setting charset and collation on every query, is it neccessary and can I suppress it?
#1

[eluser]OwenM[/eluser]
Hi,

Im using mysql 5.1 and have a site running maybe 5k requests an hour.

I recently logged out the querys sent to mysql and found

Code:
Query       SET NAMES 'utf8' COLLATE 'utf8_general_ci'

preceeding nearly every query, or set of querys.

This means about a third of the traffic between my php server and my db server is the statement above, can I stop it happening. I read about modifying mysql_driver.php to return True; but i'm not sure if that will stop these querys.

Tks,
Owen.


Messages In This Thread
Setting charset and collation on every query, is it neccessary and can I suppress it? - by El Forum - 03-25-2011, 09:58 AM



Theme © iAndrew 2016 - Forum software by © MyBB