Well some users skyrocket to the top quickly (profile hit wise) and it discourages other users from putting in the work required to catch up, so when profile hits are reset... users can effectively race for a high hit count again... I had to clear user hit counts by hand for each user in the db, and it took a very long time... so I wanted to know a quick fix... I tried checking the "hits" box in the db and dropping, but that deleted the entire well um... comprofiler table... I had everything backed up, but couldn't figure it out.
im agree with Red1000. there should be one option to set auto reset user hits for every month, i think that is a good idea