Forum: Building VoltDB Applications

Post: What can be the bottleneck in multi-threading environment performance?

What can be the bottleneck in multi-threading environment performance?
sanket
Nov 21, 2016
I am measuring the query execution time and throughput of TPCC queries for single and multi threaded environment using JMeter. For single thread the query execution time comes to 6-7 sec for the set of 15000 queries but in 6-threaded environment, the time goes to 15 sec and for 20-threaded it is 53 sec. for same set of queries. I have used the partitioning with 6 number of partitions on warehouse column, 'WAREHOUSE' and 'ITEM' tables are replicated.

What can be the bottleneck? and What can be the preferable setting of database?
bballard
Nov 28, 2016
Are you observing 6-7 sec query execution time from @Statistics or the VMC interface, or is this something you are calculating from JMeter which includes the entire request-response round trip time?
sanket
Nov 29, 2016
Yes, it is the time measured from JMeter.