I'm building a network of services, and all the services are completely different from one another, and now I'm creating a dashboard to make the experience easier to work with, creating an automatic list of the services the user uses most.

But if I want to find out which products the users use the most, how would I do that without causing heavy overload on the server? By that, I mean whenever a user goes to a page on that service, ie <http://foo.com/bar/nyancattastic2.php> I would find the keyword (app name) being 'bar', and then add a hit, by updating the row where the username is matched to 'bar' in my database with hits=hits+1

Although, putting that on every page would really destroy my server with an update query on every page.

Any ideas? Alternatively, I could ask the user what their favorite apps are, but that's more a UX question.

Any help greatly appreciated!

Cheers,
Karan

**Edit\* The levels of traffic I expect are around 3-10 Queries/Second without this suggested change!**

Thanks for all the answers!