MySQLi supports compression for connections, which can be highly beneficial for optimizing performance in environments with limited or shared bandwidth. Currently, XenForo does not offer a configuration parameter to enable this feature.
This is particularly useful for large servers that handle high traffic volumes and connect to a remote dedicated MySQL server where bandwidth might be a limiting factor.
Implementing this feature would involve a simple modification to the \XF\Db\Mysqli\Adapter::makeConnection method to add MYSQLI_CLIENT_COMPRESS flag, and introduce a new config parameter such as $config['db']['enableCompression'] => true.
Thank you for considering this suggestion.
This is particularly useful for large servers that handle high traffic volumes and connect to a remote dedicated MySQL server where bandwidth might be a limiting factor.
Implementing this feature would involve a simple modification to the \XF\Db\Mysqli\Adapter::makeConnection method to add MYSQLI_CLIENT_COMPRESS flag, and introduce a new config parameter such as $config['db']['enableCompression'] => true.
Thank you for considering this suggestion.
Upvote
1
