wiki:db/DC2/StripeRaPerf
Last modified 6 years ago Last modified on 02/01/2013 02:26:49 PM

Stripes with ra indexes: Performance Summary

Notes

For the high density FOV

  • 3044468 objects are read into memory
  • ? objects read from disk

For the low density FOV

  • 76073 objects are read into memory
  • ? objects read from disk

For the average density FOV

  • 373763 objects are read into memory
  • ? objects read from disk

Below, elapsed times for multiple runs of every test performed are listed. Detailed iostat traces for the first of these runs are available by clicking on the links.

Test FOV Row Size Time - 1st run Time - 2nd run Time - 3d run
Load test High density Skinny 1m1.231s
Fat 5m4.386s
Low density Skinny 0m2.018s
Fat 0m8.196s
Avg. density Skinny 0m8.067s
Fat 0m38.553s
Load and index test High density Skinny 1m30.129s
Fat 5m46.250s
Low density Skinny 0m2.511s
Fat 0m8.971s
Avg. density Skinny 0m10.991s
Fat 0m42.360s
Load then index test High density Skinny 1m50.968s
Fat 14m10.113s
Low density Skinny 0m2.735s
Fat 0m23.783s
Avg. density Skinny 0m12.012s
Fat 1m18.091s