Skip to content

Instantly share code, notes, and snippets.

@pwightman

pwightman/speed_test.md

Created January 29, 2013 04:13
Show Gist options
  • Save pwightman/4661732 to your computer and use it in GitHub Desktop.
Save pwightman/4661732 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
speed_test.md

100x100 (20,000 cross table records)

Indexed

Airplane time: 0.009674359999999998
Test time: 0.009538310000000008

Not Indexed

Airplane time: 0.011953609999999995
Test time: 0.011936900000000005

Result: 1.24x speed-up by indexing

300x300 (180,000 cross table records)

Indexed

Airplane time: 0.026276543333333343
Test time: 0.024844023333333323

Not Indexed

Airplane time: 0.05096246666666668
Test time: 0.04807353333333336

Result: 1.94x speed-up by indexing

As the cross table grows, so would the speed-up. I think it's safe to say Daniel loses the bet :-)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment