voteable_benchmarks: A Ruby repository from matthewrudy

Limitation¶ ↑

Current benchmark code run a for loop to create / destroy votes sequently. It does not utilize database 100%.

Results are validated after each vote / unvote and take some time too.

Solutions¶ ↑

ActiveRecordSolution: Use votes table, store counters (votes_counts, up_votes_count, down_votes_count) and votes_point in posts
NaiveMongoidSolution: Equivalent to ActiveRecordSolution (use votes collection …)
VoteableMongoidSolution: Use github.com/vinova/voteable_mongo gem
VoteableMongoMapperSolution: Use github.com/vinova/voteable_mongo gem

Benchmark Results¶ ↑

Environment¶ ↑

Linode 768MB RAM
Ubuntu 10.04 Server 32-bit
MySQL 5.1.41 Community Server
MongoDB 1.8.1
Ruby 1.9.2p180

Without additional indexing¶ ↑

./run.rb active_record skip_additional_indexes
./run.rb naive_mongoid skip_additional_indexes
./run.rb voteable_mongoid skip_additional_indexes
./run.rb voteable_mongo_mapper skip_additional_indexes

Note: skip_additional_indexes mean skip creating indexes that don’t speed up voting and unvoting processes (e.g. counters, votes_point)

ActiveRecordSolution: creating 100000 votes …

      user     system      total        real
363.950000  22.420000 386.370000 (517.987945)

ActiveRecordSolution: unvoting 100000 votes …

      user     system      total        real
274.770000  21.710000 296.480000 (417.382183)

NaiveMongoidSolution: creating 100000 votes …

    user     system      total        real
220.930000  19.050000 239.980000 (261.426427)

NaiveMongoidSolution: unvoting 100000 votes …

      user     system      total        real
193.200000  18.840000 212.040000 (234.072731)

VoteableMongoidSolution: creating 100000 votes …

      user     system      total        real
106.040000   5.420000 111.460000 (166.243362)

VoteableMongoidSolution: unvoting 100000 votes …

      user     system      total        real
100.600000   5.190000 105.790000 (151.708914)

VoteableMongoMapperSolution: creating 100000 votes …

      user     system      total        real
121.290000   5.050000 126.340000 (178.806645)

VoteableMongoMapperSolution: unvoting 100000 votes …

      user     system      total        real
122.470000   5.080000 127.550000 (174.165707)

With additional indexing¶ ↑

./run.rb active_record
./run.rb naive_mongoid
./run.rb voteable_mongoid
./run.rb voteable_mongo_mapper