[development] [Drupal7] Efficient to query nodes from multiple terms (CCK)

[Ryan Chan]

I am development a module that show a listing of node.

Currently, the node of ap specific content type has multiple CCK term
references to a specify vocabulary, i.e.  v1, v2, v3

I want to list of nodes if they matched a specify term conditions, e.g.

v1=tid1
v1=tid1, v2=tid2
v1=tid1, v2=tid2, v3=tid3
v1=tid1, v3=tid3

...


I am using subquery to query the above condition, but I am not sure if
any better method to speed up my query?


Any suggestion for my usage?


Thanks.