I have a table...
id | tid | uid | priority | status
...and would like to query it on the uid column to retrieve the uid that appears most frequently in that column. The table is indexed on uid.
The table size may become immense, so overSELECTing data and figuring it out in PHP will be too pricey.
What's the speedy way to get this done?