Optimize users table with some indices.
Introduce User.hosted scope and use it for loading of current_site.