CiviCRM Community Forums (archive)

We've been using CiviCRM on Drupal to manage a few tens of thousands of contacts for a while now, and the performance has always been terrible - several seconds delay when loading any page.

Until now. The fix was to simply add the MYSQL_CLIENT_COMPRESS flag to the connect() call in include/database.mysqli.inc. So you end up with something like

@mysqli_real_connect($connection, $url['host'], $url['user'], $url['pass'], substr($url['path'], 1), $url['port'], NULL, MYSQLI_CLIENT_FOUND_ROWS|MYSQL_CLIENT_COMPRESS);

There's a discussion on drupal.org about this (along with a bunch of hand-waving by the core team about why they aren't going to add an option for compression of the DB connection):  http://drupal.org/node/11891

This would probably only make a difference if you have a separate MySQL server from your web server, as we do. There may be an underlying issue with our network that is causing slow communication (and necessitating compression in the first place!) that we don't know about yet, but probably not.

Thanks very much for this tip.  I'm using Drupal too and have 300K contacts and am doing everything I can for speed.