Overview
Comment: | Améliorer performances et temps d'attente pour SQLite |
---|---|
Downloads: | Tarball | ZIP archive | SQL archive |
Timelines: | family | ancestors | descendants | both | trunk |
Files: | files | file ages | folders |
SHA1: |
68844e02d388d990ccc45386510c602e |
User & Date: | bohwaz on 2018-11-16 16:33:00 |
Other Links: | manifest | tags |
Context
2018-11-16
| ||
16:33 | Permettre de fusionner/mettre à jour des membres existants en utilisant le numéro de membre check-in: 62eedbbe38 user: bohwaz tags: trunk | |
16:33 | Améliorer performances et temps d'attente pour SQLite check-in: 68844e02d3 user: bohwaz tags: trunk | |
2018-11-13
| ||
15:58 | Style des logs d'erreur check-in: 00d6a26caa user: bohwaz tags: trunk | |
Changes
Modified src/include/lib/Garradin/DB.php from [69073dd36f] to [41264a6c51].
︙ | ︙ | |||
46 47 48 49 50 51 52 53 54 55 56 57 58 59 | public function connect() { if (parent::connect()) { // Activer les contraintes des foreign keys $this->db->exec('PRAGMA foreign_keys = ON;'); $this->db->createFunction('transliterate_to_ascii', ['Garradin\Utils', 'transliterateToAscii']); } } public function close() { parent::close(); | > > > > | 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 | public function connect() { if (parent::connect()) { // Activer les contraintes des foreign keys $this->db->exec('PRAGMA foreign_keys = ON;'); // 10 secondes $this->db->busyTimeout(10 * 1000); $this->db->exec('PRAGMA journal_mode = TRUNCATE;'); $this->db->createFunction('transliterate_to_ascii', ['Garradin\Utils', 'transliterateToAscii']); } } public function close() { parent::close(); |
︙ | ︙ |