[development] [Drupal7] Efficient to query nodes from multiple terms (CCK)
ryanchan404 at gmail.com
Mon Feb 28 13:37:31 UTC 2011
On Mon, Feb 28, 2011 at 3:31 AM, Larry Garfield <larry at garfieldtech.com> wrote:
> Also, subqueries in MySQL are slow only in the WHERE or HAVING clauses,
> because they run once for each possible record. That is only sometimes a
> problem in practice. In a FROM clause, however, they're perfectly fine and
> can be a very good way to "pre filter" a table, as they will only run once.
> --Larry Garfield
The reason I ask this because I believe my usage is quite common?
Shouldn't someone also need the execute similar queries? Maybe even in
the Drupal core I am not aware of.
I just wonder if any existing codes can be used.
More information about the development