I am showing a ranked user list on my page that 1000s of people run on a daily basis.
there are like 30,000 users.
right now I select * and then do an ORDER BY on their overall value, and then to show them 50 at a time i use LIMIT.
would it be better to just assign a rank to a user every hour or so, and then just do 50 selects (like, get rank 1, get rank 2...)
which one uses less memory and CPU? I have to streamline the site because the server is getting tons of traffic.
send replies to <!-- e --><a href="mailto:[email protected]">[email protected]</a><!-- e -->
there are like 30,000 users.
right now I select * and then do an ORDER BY on their overall value, and then to show them 50 at a time i use LIMIT.
would it be better to just assign a rank to a user every hour or so, and then just do 50 selects (like, get rank 1, get rank 2...)
which one uses less memory and CPU? I have to streamline the site because the server is getting tons of traffic.
send replies to <!-- e --><a href="mailto:[email protected]">[email protected]</a><!-- e -->