UBB.Developers Forums Community Development Programming MySQL and Server Configuration Slow query?

I received this email from my host about a query, anyone know what it is or if it can be indexed?

----------------------------------
Hello Steve,

You might want to index this query, I found it in your slow mysql log:

It's happening quite often, but it looks like it's probably the only bad & often query.

# Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 12348

SELECT t2.U_Language,t2.U_Email,t2.U_EmailFormat
FROM w3t_Favorites AS t1,
w3t_Users AS t2
WHERE t1.F_Thread = '1039880'
AND t1.F_Type = 'f'
AND t1.F_Owner = t2.U_Number
AND t2.U_EReplies = 'On'
;

Looks like it's searching to see if a thread is in someone's favorites. Like if a reply is made to their favorite thread - it'll check the favorites table and email those people.

Thanks, I figured you might know what it was, might be something to look at query wise I guess for 6.5, I dunno?

Thanks for posting this! Looks like we're missing a key index on that table so when a post is added it can take a little longer than it should when users have alot of favorites. I'm adding this in for the 6.5 release.