Created
April 18, 2015 13:56
-
-
Save mdkalish/fc7c6cb993b1278211df to your computer and use it in GitHub Desktop.
Query times with and without Active Record includes method for the given number of records in pg db deployed on Heroku.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| =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 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment