]> git.ipfire.org Git - thirdparty/pdns.git/commit
auth: gsqlite3backend: add missing indexes 9228/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 10:09:02 +0000 (12:09 +0200)
commit7c9d0206bda37730cd487bb44a4e2cff9d006623
treefdc9cef8daa6dad95c13f92cddc0f6d0e4827aa1
parentc41866fb65623f25fa4fe1862b21b34b0b5480c9
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