Improve performance of taxonomy queries, avoid temporary tables
|Reported by:||tott||Owned by:|
In various taxonomy queries "IN ( value )" is used even if there is only one value to check against. This is in some cases causing there creation of temporary db tables and bad performing queries.
The attached patch will ensure that only when there are more than one values to be added a "IN" statement is used. Otherwise a " = value" statement is performed.
Change History (8)
- Keywords 3.3-early westi-likes added
- Milestone changed from Awaiting Review to Future Release
- Version set to 3.2