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.mysql | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) (limited to 'database/database.mysql') diff --git a/database/database.mysql b/database/database.mysql index f9483001f..9496a906c 100644 --- a/database/database.mysql +++ b/database/database.mysql @@ -653,7 +653,8 @@ CREATE TABLE term_node ( nid int(10) unsigned NOT NULL default '0', tid int(10) unsigned NOT NULL default '0', KEY nid (nid), - KEY tid (tid) + KEY tid (tid), + PRIMARY KEY (tid,nid) ) TYPE=MyISAM; -- -- cgit v1.2.3