diff options
| author | Dries Buytaert <dries@buytaert.net> | 2005-03-23 06:12:30 +0000 |
|---|---|---|
| committer | Dries Buytaert <dries@buytaert.net> | 2005-03-23 06:12:30 +0000 |
| commit | eb2fb414fa84d5a82049dac46b52111afb008c02 (patch) | |
| tree | 0bc8c6bfd44e494da7cb45f39706d5889209ef66 /database/database.mysql | |
| parent | a7fa9552cada7d77bd340390c1e28d9cf9181e58 (diff) | |
| download | brdo-eb2fb414fa84d5a82049dac46b52111afb008c02.tar.gz brdo-eb2fb414fa84d5a82049dac46b52111afb008c02.tar.bz2 | |
- Patch by Matt and chx: improved performance of taxonomy queries. When many
terms are matched, the query would become very slow.
Diffstat (limited to 'database/database.mysql')
| -rw-r--r-- | database/database.mysql | 3 |
1 files changed, 2 insertions, 1 deletions
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; -- |