# More over-select benchmarks in suite

**URL:** <https://community.rubybench.org/t/more-over-select-benchmarks-in-suite/162>\
**Category:** Uncategorized\
**Created:** [August 31, 2017, 2:14pm UTC](https://community.rubybench.org/t/more-over-select-benchmarks-in-suite/162 "2017-08-31T14:14:26Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![bmarkons](https://sea2.discourse-cdn.com/flex016/user_avatar/community.rubybench.org/bmarkons/32/87_2.png) [@bmarkons](https://community.rubybench.org/u/bmarkons)\
**Post date:** [August 31, 2017, 2:14pm UTC](https://community.rubybench.org/t/more-over-select-benchmarks-in-suite/162/1 "2017-08-31T14:14:26Z")

</div>

- More over-select benchmarks have been added in suite. So we can measure what is the cost of over selecting.

- All setup (creating tables and inserting data) is moved to separate setup scripts which are shared across benchmarks.

- I’ve triggered backfill for Sequel, after which I will trigger for Rails.

- We only have two raw benchmarks rewritten so far – I am looking forward to rewrite other.

---

<div class="post-metadata">

**Author:** ![sam](https://sea2.discourse-cdn.com/flex016/user_avatar/community.rubybench.org/sam/32/5_2.png) [@sam](https://community.rubybench.org/u/sam)\
**Post date:** [September 6, 2017, 5:23pm UTC](https://community.rubybench.org/t/more-over-select-benchmarks-in-suite/162/2 "2017-09-06T17:23:11Z")

</div>

Is something up with this bench

[RubyBench - Long Running Ruby Benchmark](https://rubybench.org/ged/ruby-pg/commits?result_type=pg/scope_all&display_count=2000&compare_with=activerecord/postgres_scope_all) ?

How can AR be faster?

---

<div class="post-metadata">

**Author:** ![bmarkons](https://sea2.discourse-cdn.com/flex016/user_avatar/community.rubybench.org/bmarkons/32/87_2.png) [@bmarkons](https://community.rubybench.org/u/bmarkons)\
**Post date:** [September 6, 2017, 11:13pm UTC](https://community.rubybench.org/t/more-over-select-benchmarks-in-suite/162/3 "2017-09-06T23:13:29Z")

</div>

Hm, raw is 2x faster for me locally. I will take some time to inspect this issue.

---

<div class="post-metadata">

**Author:** ![bmarkons](https://sea2.discourse-cdn.com/flex016/user_avatar/community.rubybench.org/bmarkons/32/87_2.png) [@bmarkons](https://community.rubybench.org/u/bmarkons)\
**Post date:** [September 7, 2017, 3:58pm UTC](https://community.rubybench.org/t/more-over-select-benchmarks-in-suite/162/4 "2017-09-07T15:58:40Z")

</div>

The cache was outdated. It is fixed now 🙂

Have a look now : [RubyBench - Long Running Ruby Benchmark](https://rubybench.org/ged/ruby-pg/commits?result_type=pg/scope_all&compare_with=activerecord/postgres_scope_all)

raw : 45 ips  
AR : 30 ips