CODEWITHSUNDEEP
phpsqldatabase-design
James P.
James P.

Reputation: 19617

Database design - Keeping track of what users visit a profile

I currently have a table 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?

Upvotes: 0

Views: 565

Answers (1)

Revenant
Revenant

Reputation: 2984

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

Upvotes: 1

Related Questions