wiki:db/DC2/FineChunkPerf

Version 4 (modified by smm, 13 years ago) (diff)

--

Fine Chunks: Performance

Notes

For the high density FOV

  • 3596852 objects are read into memory
  • 3596852 objects read from disk

For the low density FOV

  • 105847 objects are read into memory
  • 105847 objects read from disk

For the average density FOV

  • 446289 objects are read into memory
  • 446289 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 0m42.217s
Fat 4m50.362s
Low density Skinny 0m3.589s
Fat 0m22.299s
Avg. density Skinny 0m16.066s
Fat 0m50.490s
Load and index test High density Skinny 1m1.573s
Fat 5m19.527s
Low density Skinny 0m4.206s
Fat 0m24.154s
Avg. density Skinny 0m19.058s
Fat 0m54.383s
Load then index test High density Skinny 1m31.118s
Fat 8m8.764s
Low density Skinny 0m5.717s
Fat 0m52.224s
Avg. density Skinny 0m21.408s
Fat 1m30.905s