Skip to content

Instantly share code, notes, and snippets.

@mdkalish

mdkalish/N + 1 Lesson

Created April 18, 2015 13:56
Download ZIP

Revisions

  1. mdkalish created this gist Apr 18, 2015.
    43 changes: 43 additions & 0 deletions N + 1 Lesson
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,43 @@
    =begin
    WITHOUT includes():
    For 10 records:
    Completed 200 OK in 29ms (Views: 13.9ms | ActiveRecord: 14.5ms)
    Completed 200 OK in 98ms (Views: 27.8ms | ActiveRecord: 69.2ms)
    Completed 200 OK in 116ms (Views: 44.3ms | ActiveRecord: 71.0ms)
    Completed 200 OK in 56ms (Views: 21.1ms | ActiveRecord: 32.5ms)
    Completed 200 OK in 292ms (Views: 131.9ms | ActiveRecord: 156.7ms)

    For 100 records:
    Completed 200 OK in 448ms (Views: 215.5ms | ActiveRecord: 232.2ms)
    Completed 200 OK in 254ms (Views: 113.7ms | ActiveRecord: 139.3ms)
    Completed 200 OK in 376ms (Views: 202.7ms | ActiveRecord: 172.1ms)
    Completed 200 OK in 340ms (Views: 210.9ms | ActiveRecord: 128.6ms)
    Completed 200 OK in 380ms (Views: 129.5ms | ActiveRecord: 250.2ms)

    For 1000 records:
    Completed 200 OK in 10674ms (Views: 3430.4ms | ActiveRecord: 7243.2ms)
    Completed 200 OK in 7390ms (Views: 2455.9ms | ActiveRecord: 4933.4ms)
    Completed 200 OK in 11827ms (Views: 3575.9ms | ActiveRecord: 8249.9ms)
    Completed 200 OK in 5844ms (Views: 1984.2ms | ActiveRecord: 3857.7ms)
    Completed 200 OK in 9459ms (Views: 3022.3ms | ActiveRecord: 6435.7ms)

    WITH includes():
    For 10 records:
    Completed 200 OK in 13ms (Views: 6.0ms | ActiveRecord: 6.3ms)
    Completed 200 OK in 14ms (Views: 6.0ms | ActiveRecord: 7.5ms)
    Completed 200 OK in 13ms (Views: 6.3ms | ActiveRecord: 6.2ms)
    Completed 200 OK in 14ms (Views: 6.3ms | ActiveRecord: 6.5ms)
    Completed 200 OK in 15ms (Views: 7.0ms | ActiveRecord: 6.9ms)
    For 100 records:
    Completed 200 OK in 50ms (Views: 35.6ms | ActiveRecord: 13.1ms)
    Completed 200 OK in 34ms (Views: 22.6ms | ActiveRecord: 10.1ms)
    Completed 200 OK in 35ms (Views: 22.4ms | ActiveRecord: 11.3ms)
    Completed 200 OK in 37ms (Views: 23.1ms | ActiveRecord: 13.1ms)
    Completed 200 OK in 34ms (Views: 23.6ms | ActiveRecord: 9.9ms)
    For 1000 records:
    Completed 200 OK in 509ms (Views: 371.2ms | ActiveRecord: 128.0ms)
    Completed 200 OK in 426ms (Views: 386.7ms | ActiveRecord: 38.2ms)
    Completed 200 OK in 341ms (Views: 275.4ms | ActiveRecord: 64.6ms)
    Completed 200 OK in 285ms (Views: 251.9ms | ActiveRecord: 31.9ms)
    Completed 200 OK in 314ms (Views: 278.6ms | ActiveRecord: 34.5ms)
    =end