Skip to content

Instantly share code, notes, and snippets.

@rlisowski

rlisowski/performance.txt

Created October 17, 2017 09:31
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 rlisowski/591513498df0af5f556f60b81e4a92f3 to your computer and use it in GitHub Desktop.
Save rlisowski/591513498df0af5f556f60b81e4a92f3 to your computer and use it in GitHub Desktop.
Download ZIP
MapFilter performance check
Raw
performance.txt
Warming up --------------------------------------
PostgreSQL join 1.000 i/100ms
PostgreSQL param 1.000 i/100ms
ES indexed shape 8.000 i/100ms
ES shape in query 2.000 i/100ms
Calculating -------------------------------------
PostgreSQL join 4.282 (± 0.0%) i/s - 22.000 in 5.139615s
PostgreSQL param 3.637 (± 0.0%) i/s - 19.000 in 5.231438s
ES indexed shape 115.272 (±10.4%) i/s - 576.000 in 5.054716s
ES shape in query 21.279 (± 4.7%) i/s - 106.000 in 5.006692s
Comparison:
ES indexed shape: 115.3 i/s
ES shape in query: 21.3 i/s - 5.42x slower
PostgreSQL join: 4.3 i/s - 26.92x slower
PostgreSQL param: 3.6 i/s - 31.69x slower
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment