Using MYSQLI_CLIENT_COMPRESS for speed with mysqli_real_connect

[Spartak]

Using MYSQLI_CLIENT_COMPRESS for speed with mysqli_real_connect

This may vary on your use case. In my case I have a separate database server and wanted to compress data to make it more efficient to send over.<br />
<br />
Requires edit to inc\db_mysqli.php<br />
Find<br />
<pre data-deferred="true" class="block-code line-numbers language-none"><code class="language-none">if($port)
{
$this-&gt;$link = @$connect_function($persist.$hostname, $single_connection['username'], $single_connection['password'], &quot;&quot;, $port);
}
else
{
$this-&gt;$link = @$connect_function($persist.$single_connection['hostname'], $single_connection['username'], $single_connection['password']);
}

</code></pre><br />
Change to<br />
<pre data-deferred="true" class="block-code line-numbers language-none"><code class="language-none">$this-&gt;$link = mysqli_init();

if($port)
{
mysqli_real_connect($this-&gt;$link, $persist.$hostname, $single_connection['username'], $single_connection['password'], $port,0,MYSQLI_CLIENT_COMPRESS);
}
else
{
mysqli_real_connect($this-&gt;$link, $persist.$single_connection['hostname'], $single_connection['username'], $single_connection['password'], '',0,MYSQLI_CLIENT_COMPRESS);
}

</code></pre>

Please, Log in or Register to view URLs content!