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.pgsql | |
| 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.pgsql')
| -rw-r--r-- | database/database.pgsql | 3 |
1 files changed, 2 insertions, 1 deletions
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); |