Changeset 2039

Timestamp:

02/17/11 22:53:05 (2 years ago)

Author:

ahu

Message:

further indices needed for high dnssec performance

Location:

trunk/pdns/pdns

Files:

• dnssec.schema.mysql.sql (modified) (1 diff)
• dnssec.schema.pgsql.sql (modified) (1 diff)
• dnssec.schema.sqlite3.sql (modified) (1 diff)

trunk/pdns/pdns/dnssec.schema.mysql.sql

@@ -6 +6 @@
  primary key(id)
 );
+
+create index domainmetaidindex on domainmetadata(domain_id);               
+
 
 create table cryptokeys (

trunk/pdns/pdns/dnssec.schema.pgsql.sql

@@ -9 +9 @@
  content        TEXT
 );
+
+create index domainidmetaindex on domainmetadata(domain_id);               
+
 
 create table cryptokeys (

trunk/pdns/pdns/dnssec.schema.sqlite3.sql

@@ -9 +9 @@
  content        TEXT
 );
+
+create index domainmetaidindex on domainmetadata(domain_id);
 
 create table cryptokeys (