From eb2fb414fa84d5a82049dac46b52111afb008c02 Mon Sep 17 00:00:00 2001 From: Dries Buytaert Date: Wed, 23 Mar 2005 06:12:30 +0000 Subject: - Patch by Matt and chx: improved performance of taxonomy queries. When many terms are matched, the query would become very slow. --- database/database.pgsql | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) (limited to 'database/database.pgsql') diff --git a/database/database.pgsql b/database/database.pgsql index 41665bf11..c5e33e0a3 100644 --- a/database/database.pgsql +++ b/database/database.pgsql @@ -649,7 +649,8 @@ CREATE INDEX term_hierarchy_parent_idx ON term_hierarchy(parent); CREATE TABLE term_node ( nid integer NOT NULL default '0', - tid integer NOT NULL default '0' + tid integer NOT NULL default '0', + PRIMARY KEY (tid,nid) ); CREATE INDEX term_node_nid_idx ON term_node(nid); CREATE INDEX term_node_tid_idx ON term_node(tid); -- cgit v1.2.3