Announcement

Collapse
No announcement yet.

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

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

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

    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
    replied
    Maxal,

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

    Peter Zhao

    Leave a comment:


  • maxal
    replied
    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?

    Leave a comment:


  • pzhao
    replied
    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

    Leave a comment:

Working...
X