Are you going to need all one million user info at once?
If not then you can set the query to only bring up the info you are looking for.