Tracking impressions/visits per web page

Question

Hi,

I have a site with several pages for each company and I want to show how their page is performing in terms of number of people coming to this profile.

We have already made sure that bots are excluded.

Currently, we are recording each hit in a DB with either insert (for the first request in a day to a profile) or update (for the following requests in a day to a profile). But, given that requests have gone from few thousands per days to tens of thousands per day, these inserts/updates are causing major performance issues.

Assuming no JS solution, what will be the best way to handle this?

I am using Ruby on Rails, MySQL, Memcache, Apache, HaProxy for running overall show.

Any help will be much appreciated.

Thx

Answer 1

http://www.scribd.com/doc/49575/Scaling-Rails-Presentation-From-Scribd-Launch you should start reading from slide 17. i think the performance isnt a problem, if it's possible to build solution like this for website as big as scribd.