Fix MySQL bad default buffering

Alkarex · Alkarex · commit ad4d3f76ecf3 · 2019-08-18T23:28:29.000+02:00
https://stackoverflow.com/questions/6895098/pdo-mysql-memory-consumption-with-large-result-set/6935271#6935271 https://php.net/manual/ref.pdo-mysql
diff --git a/lib/Minz/ModelPdo.php b/lib/Minz/ModelPdo.php
@@ -72,6 +72,7 @@ public function __construct($currentUser = null, $currentPrefix = null, $current
 					$driver_options[PDO::MYSQL_ATTR_INIT_COMMAND] = 'SET NAMES utf8mb4';
 					$this->prefix = $db['prefix'] . $currentUser . '_';
 					$this->bd = new MinzPDOMySql($string, $db['user'], $db['password'], $driver_options);
+					$this->bd->setAttribute(PDO::MYSQL_ATTR_USE_BUFFERED_QUERY, false);
 					break;
 				case 'sqlite':
 					$string = 'sqlite:' . join_path(DATA_PATH, 'users', $currentUser, 'db.sqlite');
