Slow Query

[FabioCesar]

# Time: 120301 9:58:30
# User@Host: xfuser[xfuser] @ localhost []
# Thread_id: 477815 Schema: plusgsm_xf QC_hit: No
# Query_time: 16.573269 Lock_time: 0.000020 Rows_sent: 20 Rows_examined: 2371700
SET timestamp=1330606710;
SELECT user.*
,
user_profile.*,
user_option.*,
user_privacy.*
FROM xf_user AS user

INNER JOIN xf_user_profile AS user_profile ON
(user_profile.user_id = user.user_id)
INNER JOIN xf_user_option AS user_option ON
(user_option.user_id = user.user_id)
INNER JOIN xf_user_privacy AS user_privacy ON
(user_privacy.user_id = user.user_id)
WHERE (user.user_state = 'valid') AND (user.is_banned = 0)
ORDER BY user.username
LIMIT 20 OFFSET 474120;

 

[Andy.N]

A good tip taken from this post, member list is removed now from my forum to keep server load down

If nobody visits that Member pages, how it will help from removing it?

 

[xml]

If nobody visits that Member pages, how it will help from removing it?

spam bots and evel action from someone keep requesting member list multiple times to bring your server down

 

[FabioCesar]

Sorry, but if the forum to create functions to be disabled when the site grow, then why waste time in development?

The solution is not simply disable the feature, but to develop queries and sub-queries to resolve any database .. once the system has been paid and want to have all active functions independent of the volume of data.