[wp-hackers] sql problems

[Aaron D. Campbell]

Just so you know, the wp_ratings table is part of a plugin (not 
WordPress core)

B. V. wrote:
> Hi.
> There are some problems with MySQL optimizations ( on big sites, are
> visibile effects ).
> >From my mysql-slow-query log:
>
> 1. *SELECT rating_username, rating_rating, rating_ip FROM wp_ratings WHERE
> rating_postid = 450;*
>
> the wp_ratings table doesn't have an index on "rating_postid" column:
>