]> git.ipfire.org Git - thirdparty/pdns.git/commit
auth: gsqlite3backend: add missing indexes 9233/head
authorKees Monshouwer <mind04@monshouwer.org>
Mon, 15 Jun 2020 09:54:05 +0000 (11:54 +0200)
committermind04 <mind04@monshouwer.org>
Mon, 15 Jun 2020 17:40:48 +0000 (19:40 +0200)
commitc1b8434153d173143c0a5dbeba02cc7030948207
treedde64d2038686ea63400ba99e0e0cc127d29cd56
parentca8247589daf2cd09f4fc4156db0612d47e7c674
auth: gsqlite3backend: add missing indexes
Sqlite3 backend was performing terrible in environments with many updates.
On a slaved root zone the performance increase was huge, 71ms -> 1ms.
Since the lack of proper indexes is causing a lot of trouble in larger environments, I target this update at 4.3.1
builder-support/debian/authoritative/debian-buster/pdns-backend-sqlite3.docs
builder-support/debian/authoritative/debian-jessie/pdns-backend-sqlite3.docs
builder-support/debian/authoritative/debian-stretch/pdns-backend-sqlite3.docs
builder-support/specs/pdns.spec
modules/gsqlite3backend/4.3.0_to_4.3.1_schema.sqlite3.sql [new file with mode: 0644]
modules/gsqlite3backend/Makefile.am
modules/gsqlite3backend/schema.sqlite3.sql