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: 68844e02d388d990ccc45386510c602e4a1665fc
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();