Depending on how busy the rooms are, the table gets accessed about 2-3 times every 5 seconds. The average item has 5 data values, with the smallest being 1 data value and the largest being 81 data values. The table tracks user names and all the IP's seen with that user name (item). I had though about breaking the table up to individual rooms, but that would mean that some of the same people would be in multiple tables. Cross referencing is done to see who else uses the same IP's that the item has on file. On average it about 1-2 seconds, with larger searches taking 3-4 seconds. Though I guess if over 500 million operations are being done per search, I can't really complain.
