Skip to content

Instantly share code, notes, and snippets.

@TimoKramer
Created February 8, 2021 15:24
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save TimoKramer/bfd16a506e4950bda7b742b362e9e6f2 to your computer and use it in GitHub Desktop.
Save TimoKramer/bfd16a506e4950bda7b742b362e9e6f2 to your computer and use it in GitHub Desktop.
benchmark datahike with stuff running on my machine
[{:db-config
{:schema-flexibility :write,
:keep-history? true,
:index :datahike.index/hitchhiker-tree,
:dh-backend :file},
:function :transaction,
:db-size 0,
:tx-size 10,
:mean-time 4.4561443}
{:db-config
{:schema-flexibility :write,
:keep-history? true,
:index :datahike.index/hitchhiker-tree,
:dh-backend :file},
:function :connection,
:db-size 1100,
:mean-time 13.024432999999998}
{:db-config
{:schema-flexibility :write,
:keep-history? true,
:index :datahike.index/hitchhiker-tree,
:dh-backend :mem},
:function :transaction,
:db-size 0,
:tx-size 10,
:mean-time 3.1466729000000004}
{:db-config
{:schema-flexibility :write,
:keep-history? true,
:index :datahike.index/hitchhiker-tree,
:dh-backend :mem},
:function :query2,
:db-size 1100,
:mean-time 4.272475699999999}
{:db-config
{:schema-flexibility :write,
:keep-history? true,
:index :datahike.index/hitchhiker-tree,
:dh-backend :mem},
:function :transaction,
:db-size 1000,
:tx-size 100,
:mean-time 2.4182451}
{:db-config
{:schema-flexibility :write,
:keep-history? true,
:index :datahike.index/hitchhiker-tree,
:dh-backend :mem},
:function :transaction,
:db-size 0,
:tx-size 1,
:mean-time 1.4347957}
{:db-config
{:schema-flexibility :write,
:keep-history? true,
:index :datahike.index/hitchhiker-tree,
:dh-backend :file},
:function :query1,
:db-size 10,
:mean-time 0.5021981999999999}
{:db-config
{:schema-flexibility :write,
:keep-history? true,
:index :datahike.index/hitchhiker-tree,
:dh-backend :mem},
:function :connection,
:db-size 2000,
:mean-time 6.0163186}
{:db-config
{:schema-flexibility :write,
:keep-history? true,
:index :datahike.index/hitchhiker-tree,
:dh-backend :file},
:function :connection,
:db-size 1,
:mean-time 3.8146148999999996}
{:db-config
{:schema-flexibility :write,
:keep-history? true,
:index :datahike.index/hitchhiker-tree,
:dh-backend :file},
:function :transaction,
:db-size 0,
:tx-size 1,
:mean-time 3.6276073}
{:db-config
{:schema-flexibility :write,
:keep-history? true,
:index :datahike.index/hitchhiker-tree,
:dh-backend :file},
:function :connection,
:db-size 2000,
:mean-time 17.9663834}
{:db-config
{:schema-flexibility :write,
:keep-history? true,
:index :datahike.index/hitchhiker-tree,
:dh-backend :file},
:function :connection,
:db-size 0,
:mean-time 2.969893725000001}
{:db-config
{:schema-flexibility :write,
:keep-history? true,
:index :datahike.index/hitchhiker-tree,
:dh-backend :mem},
:function :query1,
:db-size 1100,
:mean-time 2.8873672000000004}
{:db-config
{:schema-flexibility :write,
:keep-history? true,
:index :datahike.index/hitchhiker-tree,
:dh-backend :mem},
:function :transaction,
:db-size 0,
:tx-size 100,
:mean-time 12.1892439}
{:db-config
{:schema-flexibility :write,
:keep-history? true,
:index :datahike.index/hitchhiker-tree,
:dh-backend :mem},
:function :query2,
:db-size 1001,
:mean-time 2.7813702}
{:db-config
{:schema-flexibility :write,
:keep-history? true,
:index :datahike.index/hitchhiker-tree,
:dh-backend :mem},
:function :query2,
:db-size 2000,
:mean-time 6.020449500000001}
{:db-config
{:schema-flexibility :write,
:keep-history? true,
:index :datahike.index/hitchhiker-tree,
:dh-backend :file},
:function :connection,
:db-size 10,
:mean-time 3.5904021999999998}
{:db-config
{:schema-flexibility :write,
:keep-history? true,
:index :datahike.index/hitchhiker-tree,
:dh-backend :file},
:function :query1,
:db-size 1100,
:mean-time 6.6143546}
{:db-config
{:schema-flexibility :write,
:keep-history? true,
:index :datahike.index/hitchhiker-tree,
:dh-backend :file},
:function :connection,
:db-size 1001,
:mean-time 9.6804426}
{:db-config
{:schema-flexibility :write,
:keep-history? true,
:index :datahike.index/hitchhiker-tree,
:dh-backend :mem},
:function :query2,
:db-size 1010,
:mean-time 2.5223454}
{:db-config
{:schema-flexibility :write,
:keep-history? true,
:index :datahike.index/hitchhiker-tree,
:dh-backend :mem},
:function :connection,
:db-size 1000,
:mean-time 3.5193525}
{:db-config
{:schema-flexibility :write,
:keep-history? true,
:index :datahike.index/hitchhiker-tree,
:dh-backend :file},
:function :query2,
:db-size 1001,
:mean-time 2.7358817}
{:db-config
{:schema-flexibility :write,
:keep-history? true,
:index :datahike.index/hitchhiker-tree,
:dh-backend :mem},
:function :connection,
:db-size 10,
:mean-time 1.953573}
{:db-config
{:schema-flexibility :write,
:keep-history? true,
:index :datahike.index/hitchhiker-tree,
:dh-backend :file},
:function :transaction,
:db-size 1000,
:tx-size 100,
:mean-time 49.5500386}
{:db-config
{:schema-flexibility :write,
:keep-history? true,
:index :datahike.index/hitchhiker-tree,
:dh-backend :file},
:function :query1,
:db-size 1010,
:mean-time 6.0304891}
{:db-config
{:schema-flexibility :write,
:keep-history? true,
:index :datahike.index/hitchhiker-tree,
:dh-backend :mem},
:function :query2,
:db-size 10,
:mean-time 0.7582372}
{:db-config
{:schema-flexibility :write,
:keep-history? true,
:index :datahike.index/hitchhiker-tree,
:dh-backend :file},
:function :query1,
:db-size 100,
:mean-time 0.5225129999999999}
{:db-config
{:schema-flexibility :write,
:keep-history? true,
:index :datahike.index/hitchhiker-tree,
:dh-backend :file},
:function :query2,
:db-size 1000,
:mean-time 2.8997414}
{:db-config
{:schema-flexibility :write,
:keep-history? true,
:index :datahike.index/hitchhiker-tree,
:dh-backend :mem},
:function :query2,
:db-size 1,
:mean-time 0.9353874}
{:db-config
{:schema-flexibility :write,
:keep-history? true,
:index :datahike.index/hitchhiker-tree,
:dh-backend :file},
:function :query1,
:db-size 1000,
:mean-time 6.744930999999999}
{:db-config
{:schema-flexibility :write,
:keep-history? true,
:index :datahike.index/hitchhiker-tree,
:dh-backend :mem},
:function :query1,
:db-size 1000,
:mean-time 2.1931304}
{:db-config
{:schema-flexibility :write,
:keep-history? true,
:index :datahike.index/hitchhiker-tree,
:dh-backend :mem},
:function :transaction,
:db-size 1000,
:tx-size 1,
:mean-time 0.38640589999999997}
{:db-config
{:schema-flexibility :write,
:keep-history? true,
:index :datahike.index/hitchhiker-tree,
:dh-backend :file},
:function :connection,
:db-size 100,
:mean-time 4.441281399999999}
{:db-config
{:schema-flexibility :write,
:keep-history? true,
:index :datahike.index/hitchhiker-tree,
:dh-backend :mem},
:function :connection,
:db-size 1,
:mean-time 2.7053717999999995}
{:db-config
{:schema-flexibility :write,
:keep-history? true,
:index :datahike.index/hitchhiker-tree,
:dh-backend :file},
:function :transaction,
:db-size 1000,
:tx-size 1,
:mean-time 28.695322700000002}
{:db-config
{:schema-flexibility :write,
:keep-history? true,
:index :datahike.index/hitchhiker-tree,
:dh-backend :file},
:function :query2,
:db-size 1,
:mean-time 0.46919009999999994}
{:db-config
{:schema-flexibility :write,
:keep-history? true,
:index :datahike.index/hitchhiker-tree,
:dh-backend :mem},
:function :connection,
:db-size 1010,
:mean-time 2.7411487}
{:db-config
{:schema-flexibility :write,
:keep-history? true,
:index :datahike.index/hitchhiker-tree,
:dh-backend :mem},
:function :query1,
:db-size 100,
:mean-time 0.7200987999999999}
{:db-config
{:schema-flexibility :write,
:keep-history? true,
:index :datahike.index/hitchhiker-tree,
:dh-backend :file},
:function :query2,
:db-size 100,
:mean-time 0.5844374}
{:db-config
{:schema-flexibility :write,
:keep-history? true,
:index :datahike.index/hitchhiker-tree,
:dh-backend :file},
:function :query2,
:db-size 1010,
:mean-time 2.8712734}
{:db-config
{:schema-flexibility :write,
:keep-history? true,
:index :datahike.index/hitchhiker-tree,
:dh-backend :file},
:function :transaction,
:db-size 1000,
:tx-size 10,
:mean-time 28.978173400000003}
{:db-config
{:schema-flexibility :write,
:keep-history? true,
:index :datahike.index/hitchhiker-tree,
:dh-backend :file},
:function :transaction,
:db-size 1000,
:tx-size 1000,
:mean-time 144.60254270000001}
{:db-config
{:schema-flexibility :write,
:keep-history? true,
:index :datahike.index/hitchhiker-tree,
:dh-backend :mem},
:function :query1,
:db-size 2000,
:mean-time 3.7426694999999994}
{:db-config
{:schema-flexibility :write,
:keep-history? true,
:index :datahike.index/hitchhiker-tree,
:dh-backend :mem},
:function :query1,
:db-size 1001,
:mean-time 1.9122167}
{:db-config
{:schema-flexibility :write,
:keep-history? true,
:index :datahike.index/hitchhiker-tree,
:dh-backend :file},
:function :transaction,
:db-size 0,
:tx-size 100,
:mean-time 13.479124100000002}
{:db-config
{:schema-flexibility :write,
:keep-history? true,
:index :datahike.index/hitchhiker-tree,
:dh-backend :mem},
:function :transaction,
:db-size 0,
:tx-size 1000,
:mean-time 71.3227524}
{:db-config
{:schema-flexibility :write,
:keep-history? true,
:index :datahike.index/hitchhiker-tree,
:dh-backend :mem},
:function :query1,
:db-size 1010,
:mean-time 1.9132082000000004}
{:db-config
{:schema-flexibility :write,
:keep-history? true,
:index :datahike.index/hitchhiker-tree,
:dh-backend :mem},
:function :query1,
:db-size 10,
:mean-time 0.5873173}
{:db-config
{:schema-flexibility :write,
:keep-history? true,
:index :datahike.index/hitchhiker-tree,
:dh-backend :mem},
:function :query2,
:db-size 1000,
:mean-time 2.9296394}
{:db-config
{:schema-flexibility :write,
:keep-history? true,
:index :datahike.index/hitchhiker-tree,
:dh-backend :mem},
:function :query1,
:db-size 1,
:mean-time 1.212704}
{:db-config
{:schema-flexibility :write,
:keep-history? true,
:index :datahike.index/hitchhiker-tree,
:dh-backend :file},
:function :connection,
:db-size 1010,
:mean-time 11.0968302}
{:db-config
{:schema-flexibility :write,
:keep-history? true,
:index :datahike.index/hitchhiker-tree,
:dh-backend :mem},
:function :connection,
:db-size 1100,
:mean-time 4.936976400000001}
{:db-config
{:schema-flexibility :write,
:keep-history? true,
:index :datahike.index/hitchhiker-tree,
:dh-backend :file},
:function :query2,
:db-size 2000,
:mean-time 6.6203245}
{:db-config
{:schema-flexibility :write,
:keep-history? true,
:index :datahike.index/hitchhiker-tree,
:dh-backend :mem},
:function :connection,
:db-size 0,
:mean-time 2.1340672499999997}
{:db-config
{:schema-flexibility :write,
:keep-history? true,
:index :datahike.index/hitchhiker-tree,
:dh-backend :mem},
:function :query2,
:db-size 100,
:mean-time 0.9606324}
{:db-config
{:schema-flexibility :write,
:keep-history? true,
:index :datahike.index/hitchhiker-tree,
:dh-backend :file},
:function :query1,
:db-size 1001,
:mean-time 5.3087356}
{:db-config
{:schema-flexibility :write,
:keep-history? true,
:index :datahike.index/hitchhiker-tree,
:dh-backend :file},
:function :query2,
:db-size 1100,
:mean-time 3.8221671}
{:db-config
{:schema-flexibility :write,
:keep-history? true,
:index :datahike.index/hitchhiker-tree,
:dh-backend :mem},
:function :connection,
:db-size 100,
:mean-time 2.7106898999999998}
{:db-config
{:schema-flexibility :write,
:keep-history? true,
:index :datahike.index/hitchhiker-tree,
:dh-backend :file},
:function :transaction,
:db-size 0,
:tx-size 1000,
:mean-time 99.71944700000002}
{:db-config
{:schema-flexibility :write,
:keep-history? true,
:index :datahike.index/hitchhiker-tree,
:dh-backend :mem},
:function :transaction,
:db-size 1000,
:tx-size 1000,
:mean-time 60.8313366}
{:db-config
{:schema-flexibility :write,
:keep-history? true,
:index :datahike.index/hitchhiker-tree,
:dh-backend :file},
:function :query2,
:db-size 10,
:mean-time 0.5287252000000001}
{:db-config
{:schema-flexibility :write,
:keep-history? true,
:index :datahike.index/hitchhiker-tree,
:dh-backend :file},
:function :query1,
:db-size 1,
:mean-time 0.4916392}
{:db-config
{:schema-flexibility :write,
:keep-history? true,
:index :datahike.index/hitchhiker-tree,
:dh-backend :file},
:function :query1,
:db-size 2000,
:mean-time 9.3499796}
{:db-config
{:schema-flexibility :write,
:keep-history? true,
:index :datahike.index/hitchhiker-tree,
:dh-backend :mem},
:function :connection,
:db-size 1001,
:mean-time 2.6282669000000007}
{:db-config
{:schema-flexibility :write,
:keep-history? true,
:index :datahike.index/hitchhiker-tree,
:dh-backend :mem},
:function :transaction,
:db-size 1000,
:tx-size 10,
:mean-time 0.5604125}
{:db-config
{:schema-flexibility :write,
:keep-history? true,
:index :datahike.index/hitchhiker-tree,
:dh-backend :file},
:function :connection,
:db-size 1000,
:mean-time 10.903770079999997}]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment