Skip to content

Instantly share code, notes, and snippets.

@lakshmanok

lakshmanok/biengine_measures.csv Secret

Last active March 15, 2021 22:50
Show Gist options
  • Save lakshmanok/0996f700ba3154d4f3d5826a973f445b to your computer and use it in GitHub Desktop.
Save lakshmanok/0996f700ba3154d4f3d5826a973f445b to your computer and use it in GitHub Desktop.
Download ZIP
Timing stats BI Engine
Raw
biengine_measures.csv
Query Table size Cost (orig) Time (orig) Cost (w/ BI Eng) Time (w/ BI Eng) Cost saving Time saving
COST_BY_STATE 460 MB 6452 sms 0.61 s 324 sms 0.25 s 20x 2.4x
TIPS_BY_TYPE 3.1 GB 47012 sms 0.82 s 4036 sms 0.38 s 11.6x 2.1x
AIR_QUALITY 104 MB 1068 sms 0.51 s 132 sms 0.27 s 8.1x 1.9x
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment