Database design - Keeping track of what users visit a profile

I currently have a tab开发者_高级运维le that pairs a profile id and user id to keep track of who visits a profile. I've realized that this could generate a big number of permutations depending on the number of users. Is there a more efficient way of doing this?

You could keep it in database. If you have many active users, you might want to keep such records in an another database.

You could also go with keeping them with cache in files which will take some load over CPU of your server.

Oh before I forget, keeping them even in the same database, you could put your mysql database in partitions like hard drives.

Please read this article if you want to keep them in database, this could be the solution for you MySQL Partitioning