Slow Queries from user stats killing big site

Hi,

I use User stats on my website to log the ips where people come from. But the user stats module uses some really slow queries, killing my website. That's why I needed to stop it. An example of a slow query which took 11 seconds is posted below! It is because of the DISTINCT method used in the query. This should and can be done differently.

# Time: 130113  9:19:49
# User@Host: admin_adk[admin_adk] @ localhost []
# Query_time: 11.153548  Lock_time: 0.000182 Rows_sent: 11  Rows_examined: 10731565

SET timestamp=1358065189;
SELECT DISTINCT user_stats_ips.ip_address AS user_stats_ips_ip_address, user_stats_ips.first_seen_timestamp AS user_stats_ips_first_seen_timestamp, users.uid AS uid, (SELECT COUNT(usi.uid)
      FROM (SELECT DISTINCT(uid), ip_address FROM user_stats_ips) usi
      WHERE usi.ip_address = user_stats_ips.ip_address) AS user_stats_ips_ip_user_count, (SELECT COUNT(usi.ip_address)
      FROM (SELECT DISTINCT(uid), ip_address FROM user_stats_ips) usi
      WHERE usi.uid = user_stats_ips.uid) AS user_stats_ips_user_ip_count
FROM
users users
LEFT JOIN user_stats_ips user_stats_ips ON users.uid = user_stats_ips.uid
WHERE (( (users.uid = '1' ) ))
ORDER BY user_stats_ips_user_ip_count DESC;

The former query is build on user/1/ip_tracking . All pages showing tables of ip information are very slow:
admin/reports/ip_tracking/by_ip/11.123.12.123
admin/reports/ip_tracking/by_user/someusername