Overview
SHA1:68844e02d388d990ccc45386510c602e4a1665fc
Date: 2018-11-16 16:33:00
User: bohwaz
Comment:Améliorer performances et temps d'attente pour SQLite
Timelines: family | ancestors | descendants | both | trunk
Downloads: Tarball | ZIP archive
Other Links: files | file ages | folders | manifest
Tags And Properties
Context
2018-11-16
16:33
[62eedbbe38] Permettre de fusionner/mettre à jour des membres existants en utilisant le numéro de membre (user: bohwaz, tags: trunk)
16:33
[68844e02d3] Améliorer performances et temps d'attente pour SQLite (user: bohwaz, tags: trunk)
2018-11-13
15:58
[00d6a26caa] Style des logs d'erreur (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();