Skip to content

Instantly share code, notes, and snippets.

@debborafernandess

debborafernandess/benchmark_sequel_vs_activerecord.csv

Last active July 19, 2018 01:13
Show Gist options
  • Save debborafernandess/b91972a9d51f62fb65a9420247ab7451 to your computer and use it in GitHub Desktop.
Save debborafernandess/b91972a9d51f62fb65a9420247ab7451 to your computer and use it in GitHub Desktop.
Download ZIP
Sequel vs ActiveRecord
Raw
benchmark_sequel_vs_activerecord.csv
ORM-Adapter Operation benchmark User CPU time System CPU time Total CPU time Real time Memory used in kb Transaction or Not
sequel-mysql Model Object Creation: 1600 objects 0.536818 0.080193 0.639675 1.156077 6072 No Transaction
activerecord-mysql Model Object Creation: 1600 objects 0.986834 0.051411 1.058469 1.481707 2436 No Transaction
sequel-mysql Model Object Creation: 1600 objects 0.375353 0.043466 0.440293 0.640171 264 Transaction
activerecord-mysql Model Object Creation: 1600 objects 0.638790 0.014195 0.675404 0.780479 0 Transaction
sequel-mysql Model Object Select: 3200 objects 32 times 0.125732 0.000409 0.145452 0.182796 0 No Transaction
activerecord-mysql Model Object Select: 3200 objects 32 times 0.841494 0.004042 0.865443 0.903764 5016 No Transaction
sequel-mysql Model Object Select: 3200 objects 32 times 0.132256 0.000000 0.152481 0.190061 0 Transaction
activerecord-mysql Model Object Select: 3200 objects 32 times 0.844372 0.003153 0.866892 0.905380 0 Transaction
sequel-mysql Model Object Select PK: 320 objects 32 times 0.552393 0.142847 0.718423 1.347740 26928 No Transaction
activerecord-mysql Model Object Select PK: 320 objects 32 times 1.523991 0.102327 1.646347 2.311988 0 No Transaction
sequel-mysql Model Object Select PK: 320 objects 32 times 0.505881 0.096231 0.623812 1.172242 2376 Transaction
activerecord-mysql Model Object Select PK: 320 objects 32 times 1.502174 0.092266 1.617027 2.214341 0 Transaction
sequel-mysql Model Object Select Hash: 320 objects 32 times 0.854882 0.100637 0.978392 1.617659 0 No Transaction
activerecord-mysql Model Object Select Hash: 320 objects 32 times 1.613077 0.067471 1.702388 2.358288 0 No Transaction
sequel-mysql Model Object Select Hash: 320 objects 32 times 0.820571 0.081678 0.925883 1.513278 0 Transaction
activerecord-mysql Model Object Select Hash: 320 objects 32 times 1.504241 0.111096 1.636644 2.167026 0 Transaction
sequel-mysql Model Object Select and Save: 1600 objects 0.368734 0.055756 0.446334 0.919908 0 No Transaction
activerecord-mysql Model Object Select and Save: 1600 objects 1.047433 0.063828 1.131602 1.698245 0 No Transaction
sequel-mysql Model Object Select and Save: 1600 objects 0.210185 0.052603 0.285753 0.453119 0 Transaction
activerecord-mysql Model Object Select and Save: 1600 objects 0.702941 0.024327 0.749491 0.930391 0 Transaction
sequel-mysql Model Object Destruction: 3200 objects 0.362886 0.087056 0.473526 1.208152 0 No Transaction
activerecord-mysql Model Object Destruction: 3200 objects 1.170276 0.105846 1.295956 2.168026 528 No Transaction
sequel-mysql Model Object Destruction: 3200 objects 0.118407 0.032716 0.175355 0.337858 0 Transaction
activerecord-mysql Model Object Destruction: 3200 objects 0.557420 0.033086 0.610087 0.803009 1848 Transaction
sequel-mysql Model Object And Associated Object Creation: 640 objects 0.490698 0.062455 0.574800 0.989157 0 No Transaction
activerecord-mysql Model Object And Associated Object Creation: 640 objects 0.953893 0.033530 1.006724 1.352617 0 No Transaction
sequel-mysql Model Object And Associated Object Creation: 640 objects 0.373359 0.019184 0.413339 0.572608 0 Transaction
activerecord-mysql Model Object And Associated Object Creation: 640 objects 0.644460 0.027898 0.692730 0.784041 0 Transaction
sequel-mysql Model Object and Associated Object Destruction: 800 objects 0.314973 0.026853 0.363475 0.927033 0 No Transaction
activerecord-mysql Model Object and Associated Object Destruction: 800 objects 1.145363 0.064961 1.232522 1.940542 0 No Transaction
sequel-mysql Model Object and Associated Object Destruction: 800 objects 0.167526 0.007687 0.194984 0.443332 0 Transaction
activerecord-mysql Model Object and Associated Object Destruction: 800 objects 0.866111 0.030645 0.917978 1.276158 0 Transaction
sequel-mysql Eager Loading Query Per Association With 1-1 Records: 640 objects 22 times 0.117581 0.000000 0.137984 0.163069 0 No Transaction
activerecord-mysql Eager Loading Query Per Association With 1-1 Records: 640 objects 22 times 1.001863 0.004217 1.026146 1.052713 264 No Transaction
sequel-mysql Eager Loading Query Per Association With 1-1 Records: 640 objects 22 times 0.124817 0.000405 0.147089 0.173917 0 Transaction
activerecord-mysql Eager Loading Query Per Association With 1-1 Records: 640 objects 22 times 1.072967 0.000150 1.092288 1.120811 0 Transaction
sequel-mysql Eager Loading Single Query With 1-1 Records: 640 objects 22 times 0.124785 0.004292 0.148876 0.171979 0 No Transaction
activerecord-mysql Eager Loading Single Query With 1-1 Records: 640 objects 22 times 1.253495 0.001383 1.279865 1.307822 0 No Transaction
sequel-mysql Eager Loading Single Query With 1-1 Records: 640 objects 22 times 0.130936 0.000949 0.154519 0.177550 0 Transaction
activerecord-mysql Eager Loading Single Query With 1-1 Records: 640 objects 22 times 1.229724 0.004218 1.253201 1.278693 0 Transaction
sequel-mysql Eager Loading Query Per Association With 1-32 Records: 1024 objects 22 times 0.085859 0.000197 0.105151 0.124619 0 No Transaction
activerecord-mysql Eager Loading Query Per Association With 1-32 Records: 1024 objects 22 times 0.894312 0.001030 0.915580 0.935757 0 No Transaction
sequel-mysql Eager Loading Query Per Association With 1-32 Records: 1024 objects 22 times 0.082050 0.002003 0.107288 0.125881 0 Transaction
activerecord-mysql Eager Loading Query Per Association With 1-32 Records: 1024 objects 22 times 0.833766 0.008834 0.866509 0.887000 0 Transaction
sequel-mysql Eager Loading Single Query With 1-32 Records: 1024 objects 22 times 0.135569 0.000924 0.155766 0.177411 0 No Transaction
activerecord-mysql Eager Loading Single Query With 1-32 Records: 1024 objects 22 times 1.046942 0.000213 1.066866 1.089856 0 No Transaction
sequel-mysql Eager Loading Single Query With 1-32 Records: 1024 objects 22 times 0.133823 0.000171 0.152840 0.174850 0 Transaction
activerecord-mysql Eager Loading Single Query With 1-32 Records: 1024 objects 22 times 1.033364 0.000733 1.055379 1.078372 524 Transaction
sequel-mysql Eager Loading Query Per Association With 1-32-32 Records: 2048 objects 9 times 0.070753 0.000000 0.090696 0.110778 0 No Transaction
activerecord-mysql Eager Loading Query Per Association With 1-32-32 Records: 2048 objects 9 times 0.538588 0.000381 0.558219 0.578807 0 No Transaction
sequel-mysql Eager Loading Query Per Association With 1-32-32 Records: 2048 objects 9 times 0.067566 0.002950 0.090817 0.111308 0 Transaction
activerecord-mysql Eager Loading Query Per Association With 1-32-32 Records: 2048 objects 9 times 0.544151 0.003647 0.568152 0.588024 0 Transaction
sequel-mysql Eager Loading Single Query With 1-32-32 Records: 2048 objects 1 time 0.263311 0.004175 0.288863 0.560855 0 No Transaction
activerecord-mysql Eager Loading Single Query With 1-32-32 Records: 2048 objects 1 time 0.413812 0.019896 0.455322 0.801280 17420 No Transaction
sequel-mysql Eager Loading Single Query With 1-32-32 Records: 2048 objects 1 time 0.253919 0.000102 0.273146 0.536150 0 Transaction
activerecord-mysql Eager Loading Single Query With 1-32-32 Records: 2048 objects 1 time 0.349468 0.000211 0.370351 0.676651 0 Transaction
sequel-mysql Lazy Loading With 1-1 Records: 640 objects 1 time 0.092012 0.007994 0.123425 0.301963 0 No Transaction
activerecord-mysql Lazy Loading With 1-1 Records: 640 objects 1 time 0.390182 0.012756 0.426598 0.631035 0 No Transaction
sequel-mysql Lazy Loading With 1-1 Records: 640 objects 1 time 0.076041 0.000000 0.094782 0.247607 0 Transaction
activerecord-mysql Lazy Loading With 1-1 Records: 640 objects 1 time 0.405997 0.021684 0.452084 0.678489 0 Transaction
sequel-mysql Lazy Loading With 1-32 Records: 1024 objects 16 times 0.115797 0.000185 0.139295 0.337388 0 No Transaction
activerecord-mysql Lazy Loading With 1-32 Records: 1024 objects 16 times 0.781704 0.013097 0.815444 1.039191 0 No Transaction
sequel-mysql Lazy Loading With 1-32 Records: 1024 objects 16 times 0.139776 0.012479 0.173249 0.476770 0 Transaction
activerecord-mysql Lazy Loading With 1-32 Records: 1024 objects 16 times 0.777622 0.014854 0.815521 1.023887 0 Transaction
sequel-mysql Light Threading with 6 threads 0.114571 0.020990 0.156722 0.345880 6104 No Transaction
activerecord-mysql Light Threading with 6 threads 0.309306 0.022099 0.352231 0.532017 4424 No Transaction
sequel-mysql Heavy Threading with 32 threads 0.551097 0.098475 0.670301 1.595322 13468 No Transaction
activerecord-mysql Heavy Threading with 32 threads 1.647982 0.063506 1.735167 2.750547 2104 No Transaction
activerecord-mysql Model Object Select JSON Nested: 320 objects 32 times 0.023689 0.000000 0.043043 0.042858 0 No Transaction
activerecord-mysql Model Object Select JSON Nested: 320 objects 32 times 0.026409 0.000126 0.047072 0.044176 0 Transaction
activerecord-mysql Model Object Update JSON Nested: 320 objects 32 times 0.024489 0.000032 0.044641 0.041880 0 No Transaction
activerecord-mysql Model Object Update JSON Nested: 320 objects 32 times 0.032383 0.000030 0.057503 0.054572 0 Transaction
activerecord-mysql Model Object Update JSON: 320 objects 32 times 0.024741 0.000046 0.045986 0.043179 0 No Transaction
activerecord-mysql Model Object Update JSON: 320 objects 32 times 0.024942 0.000055 0.045316 0.042688 0 Transaction
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment