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 -v 0.0.2
Authors

Jesse Storimer

2,043 total downloads 849 for this version
Owners

83a9c9496491ad52f6d6b0be9ae4fb3e0c38c5a6ba0cba991e66456e2c3795b7

Gemfile
gem 'multirow_counter', '~> 0.0.2'
Versions
  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
Development Dependencies
  1. mysql2 >= 0