Ok. So I deleted that user and got rid of the above SQL error message, but with further testing. I determined it is definitely the blogs that is running slowly. For instance, my homepage loads in 0.5 seconds without the blog comments and update blocks and in 6-9 seconds with the blog comments and updates showing.
SQL shows the following query run against every user in the database. Not sure that it should be querying every user?
引用：
SELECT * FROM xoops_users u, xoops_user_profile p WHERE u.uid = p.profileid AND uid = '494' LIMIT 0, 1
( 0.000198)
but otherwise no error messages in sql debug.
Any ideas on why it's so slow?
Re: WordPress/0.5.0