arctic icon indicating copy to clipboard operation
arctic copied to clipboard

Comparison of chunkstore and version store performance

Open TomTaylorLondon opened this issue 6 years ago • 8 comments

See attached. results.xlsx

TomTaylorLondon avatar Jul 01 '18 19:07 TomTaylorLondon

What is the issue @TomTaylorLondon ? Which of those numbers need to be improved?

bmoscon avatar Jul 01 '18 19:07 bmoscon

@bmoscon @jamesblackburn in summary:

  • CS faster for large writes. Up to 20% in some cases (median 7%)
  • Read performance in-line.
  • CS twice as fast when appending a single day.

TomTaylorLondon avatar Jul 01 '18 19:07 TomTaylorLondon

@bmoscon - we've been talking recently about combining both CS and VS into a single versioned chunk store. I'm surprised that CS is quicker than VS - the one variable I didn't test is changing the number of observations per day, my prior was that VS would be quicker. I can re-run with fewer observations per day and see if VS pulls ahead.

TomTaylorLondon avatar Jul 01 '18 19:07 TomTaylorLondon

What’s the test code?

jamesblackburn avatar Jul 01 '18 19:07 jamesblackburn

I'll clean it up and add to a branch.

TomTaylorLondon avatar Jul 01 '18 20:07 TomTaylorLondon

https://github.com/manahl/arctic/blob/582-performance-bench/benchmarks/cs_vs_vs.py

TomTaylorLondon avatar Jul 01 '18 20:07 TomTaylorLondon

@TomTaylorLondon for chunkstore are those appends or updates?

bmoscon avatar Jul 01 '18 20:07 bmoscon

Writes and appends. (no updates)

TomTaylorLondon avatar Jul 01 '18 20:07 TomTaylorLondon