Pastable version of Sequel threaded benchmark

<div style="overflow:auto;border:solid 1px #ccc;background:#000;color:#F8F8F8">
          <div class="section">
            
            <pre style="float:left;margin:0 10px;border-right:0;color:#666;">1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50</pre>
            <pre class="sunburst"><span style="color:#E28964;">require</span> <span style="color:#65B042;"><span style="color:#65B042;">'</span>rubygems<span style="color:#65B042;">'</span></span>
<span style="color:#E28964;">require</span> <span style="color:#65B042;"><span style="color:#65B042;">'</span>sequel<span style="color:#65B042;">'</span></span>
<span style="color:#E28964;">require</span> <span style="color:#65B042;"><span style="color:#65B042;">'</span>benchmark<span style="color:#65B042;">'</span></span>

<span style="color:#AEAEAE;font-style:italic;"><span style="color:#AEAEAE;font-style:italic;">#</span> set up Sequel</span>
<span style="color:#9B859D;">Sequel</span>::<span style="color:#89BDFF;">Model</span>.<span style="color:#89BDFF;">db</span> <span style="color:#E28964;">=</span> <span style="color:#3E87E3;">DB</span> <span style="color:#E28964;">=</span> <span style="color:#9B859D;">Sequel</span>.<span style="color:#89BDFF;">sqlite</span>(<span style="color:#65B042;"><span style="color:#65B042;">'</span>perf_sequel.db<span style="color:#65B042;">'</span></span>)

<span style="color:#E28964;">class</span> <span style="text-decoration:underline;">SequelItem<span style="color:#9B5C2E;font-style:italic;"> <span style="color:#9B5C2E;font-style:italic;">&lt;</span> Sequel::Model</span></span>(<span style="color:#3387CC;"><span style="color:#3387CC;">:</span>items</span>)
  set_schema <span style="color:#E28964;">do</span>
    primary_key <span style="color:#3387CC;"><span style="color:#3387CC;">:</span>id</span>
    varchar <span style="color:#3387CC;"><span style="color:#3387CC;">:</span>name</span>
    text <span style="color:#3387CC;"><span style="color:#3387CC;">:</span>description</span>
    boolean <span style="color:#3387CC;"><span style="color:#3387CC;">:</span>active</span>
    timestamp <span style="color:#3387CC;"><span style="color:#3387CC;">:</span>created_at</span>
  <span style="color:#E28964;">end</span>
<span style="color:#E28964;">end</span>

<span style="color:#AEAEAE;font-style:italic;"><span style="color:#AEAEAE;font-style:italic;">#</span> create schema and populate</span>
<span style="color:#9B859D;">SequelItem</span>.<span style="color:#89BDFF;">create_table!</span>

<span style="color:#3387CC;">1000</span>.<span style="color:#89BDFF;">times</span> <span style="color:#E28964;">do </span>|<span style="color:#3E87E3;">i</span>|
  <span style="color:#3E87E3;">DB</span>[<span style="color:#3387CC;"><span style="color:#3387CC;">:</span>items</span>].<span style="color:#89BDFF;">insert</span>(<span style="color:#3387CC;"><span style="color:#3387CC;">:</span>name</span> =&gt; <span style="color:#65B042;"><span style="color:#65B042;">&quot;</span>record_<span style="color:#DAEFA3;"><span style="color:#DAEFA3;">#{</span>i<span style="color:#DAEFA3;">}</span></span><span style="color:#65B042;">&quot;</span></span>, <span style="color:#3387CC;"><span style="color:#3387CC;">:</span>description</span> =&gt; <span style="color:#65B042;"><span style="color:#65B042;">&quot;</span>test record<span style="color:#65B042;">&quot;</span></span>, <span style="color:#3387CC;"><span style="color:#3387CC;">:</span>active</span> =&gt; i.<span style="color:#89BDFF;">remainder</span>(<span style="color:#3387CC;">3</span>).<span style="color:#89BDFF;">zero?</span>, <span style="color:#3387CC;"><span style="color:#3387CC;">:</span>created_at</span> =&gt; <span style="color:#9B859D;">Time</span>.<span style="color:#89BDFF;">now</span>)
<span style="color:#E28964;">end</span>

<span style="color:#AEAEAE;font-style:italic;"><span style="color:#AEAEAE;font-style:italic;">#</span> run benchmarks</span>
<span style="color:#9B859D;">Benchmark</span>.<span style="color:#89BDFF;">bmbm</span> <span style="color:#E28964;">do </span>|<span style="color:#3E87E3;">x</span>|
  
  x.<span style="color:#89BDFF;">report</span>(<span style="color:#65B042;"><span style="color:#65B042;">'</span>sequel single-thread<span style="color:#65B042;">'</span></span>) <span style="color:#E28964;">do</span>
    <span style="color:#3387CC;">100</span>.<span style="color:#89BDFF;">times</span> <span style="color:#E28964;">do</span>
      <span style="color:#9B859D;">SequelItem</span>.<span style="color:#89BDFF;">where</span>(<span style="color:#3387CC;"><span style="color:#3387CC;">:</span>active</span> =&gt; <span style="color:#3387CC;">false</span>).<span style="color:#89BDFF;">all</span>
    <span style="color:#E28964;">end</span>
  <span style="color:#E28964;">end</span>
  
  x.<span style="color:#89BDFF;">report</span>(<span style="color:#65B042;"><span style="color:#65B042;">'</span>sequel threaded<span style="color:#65B042;">'</span></span>) <span style="color:#E28964;">do</span>
    threads <span style="color:#E28964;">=</span> []
    <span style="color:#3387CC;">10</span>.<span style="color:#89BDFF;">times</span> <span style="color:#E28964;">do</span>
      t <span style="color:#E28964;">=</span> <span style="color:#9B859D;">Thread</span>.<span style="color:#89BDFF;">new</span> <span style="color:#E28964;">do</span>
        <span style="color:#3387CC;">10</span>.<span style="color:#89BDFF;">times</span> <span style="color:#E28964;">do</span>
          <span style="color:#9B859D;">SequelItem</span>.<span style="color:#89BDFF;">where</span>(<span style="color:#3387CC;"><span style="color:#3387CC;">:</span>active</span> =&gt; <span style="color:#3387CC;">false</span>).<span style="color:#89BDFF;">all</span>
        <span style="color:#E28964;">end</span>
      <span style="color:#E28964;">end</span>
      threads.<span style="color:#89BDFF;">push</span>(t)
    <span style="color:#E28964;">end</span>
    threads.<span style="color:#89BDFF;">each</span> { |<span style="color:#3E87E3;">t</span>| t.<span style="color:#89BDFF;">join</span> }
  <span style="color:#E28964;">end</span>
  
<span style="color:#E28964;">end</span>

<span style="color:#9B859D;">SequelItem</span>.<span style="color:#89BDFF;">drop_table</span>

</pre>
          </div>
        </div>

<a href="http://refactormycode.com/codes/239-sequel-threaded-benchmark" style="color:#fff" title="As seen on RefactorMyCode.com"><img alt="Small_logo" src="http://refactormycode.com/images/small_logo.gif" style="border:0" /></a>

counter free hit invisible