[wp-hackers] geocomments?

Stewart Ugelow stewart at ugelow.com
Thu Apr 13 23:46:09 GMT 2006


> All of which is more efficient than querying against a single table with
> an extra WHERE parameter, indexed or not.

Really? Even if it's a multi-column index as described at
http://dev.mysql.com/doc/refman/4.1/en/multiple-column-indexes.html?

And doesn't Mark's patch already have multiple where clauses in the
wp_get_meta() functions?

$metalist = $wpdb->get_results("SELECT meta_value FROM $table WHERE
$id_col = '$id' AND meta_key = '$key'", ARRAY_N);

--Stewart, who is not not trying to beat a dead horse but is genuinely curious.

--

Stewart Ugelow
www.ugelow.com


More information about the wp-hackers mailing list