search

yugabyte / tpcc

Repo to run TPCC benchmarks against YugabyteDB
Other
24 stars 21 forks source link

Reduce client to database calls for New Order inserts and selects #45

Closed psudheer21 closed 4 years ago

psudheer21 commented 4 years ago

Summary: This change involves:

  1. Batching the select for entries in Item into 1 statement using the 'IN' predicate.
  2. Batching the select for entries in Stock into 1 statement using the 'IN' predicate.
  3. Batching the insert for all entries into OrderLine using the multirow VALUES syntax.

Reviewers: Karthik, Mihnea