RubyGems.org

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
Authors

Jesse Storimer

1,606 total downloads 732 for this version
Owners

83a9c9496491ad52f6d6b0be9ae4fb3e

Gemfile
gem 'multirow_counter', '~> 0.0.2'
Versions
  1. 0.0.2 July 17, 2012 (5 KB)
  2. 0.0.1 July 16, 2012 (5 KB)
Runtime Dependencies
  1. activerecord >= 0
Development Dependencies
  1. mysql2 >= 0