(just fyi, I'm a dba/systems engineer for a vbulletin forum with nearly 17 million posts, and 700,000 users, plus other mysql databases as well)
Can you give me an explain on that query?
Simply run it through mysql with "explain" tacked on the beginning before the select.
That will tell me everything I need to know.
Michael
|