[wp-hackers] sql problems

Aaron D. Campbell aaron at xavisys.com
Tue Apr 21 14:59:41 GMT 2009

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:

More information about the wp-hackers mailing list