Forum: VoltDB Architecture

Post: multi-partition read only stored procedures (select) over replicated tables

multi-partition read only stored procedures (select) over replicated tables
maxal
May 20, 2015
Hi.

Sorry it's not clear for me. How does VoltDB executes multi-partition stored procedure which only selects from replicated table?

Does it lock all partitions and blocks execution of any other sql statements while processing? Or it optimizes the request and executes it on only one partition allowing other partitions to process other requests?

Thanks.
pzhao
May 20, 2015
Maxal,

Your second response is the correct one. VoltDB optimizes a read only multi-partitioned stored procedure on a replicated table as a single partitioned. This is the case because replicated tables are on every partition.

Peter Zhao
maxal
May 20, 2015
Hi Peter,

Thank you for response.

Then I have question how does it select partition for running that request? Is it any free one? Will it be able to process several similar requests in parallel on diferent partitions?
pzhao
May 21, 2015
Maxal,

The node that gets the request will process it. These requests can be done in parallel on different partitions.

Peter Zhao