Typically SQL is not a great place to store a counter that is incremented often. For instance if you're counting the number of visits to a page by incrementing a SQL column and that page gets popular then there's a good chance that the SQL counter will become a benchmark. This is because doing an UPDATE on the row in question locks the row during the course of the UPDATE. So for many concurrent UPDATES there will be lots of lock contention. This gem helps with that.

installgem install multirow_counter

Jesse Storimer

2,043 total downloads 199 for this version


gem 'multirow_counter', '~> 0.0.3'
  1. 0.0.3 June 23, 2014 (10 KB)
  2. 0.0.2 July 17, 2012 (5 KB)
  3. 0.0.1 July 16, 2012 (5 KB)
Runtime Dependencies
  1. activerecord >= 0
Ruby Dependency
  1. >= 0