about stored procedure to query a single replicated table
Sep 1, 2017
Do I have to partition the procedure on another unnecessary partitioned table ? Otherwise, the procedure is multi-partitioned and have performance issues.(such as global lock)
Is this confirmed? Why can't voltdb analyze the procedure and find out only one replicated table is involved, so just pick any idle partition to execute it?
What's the recommended way to write a stored procedure to query a single replicated table?
Thanks in advance.
-Xiang
Is this confirmed? Why can't voltdb analyze the procedure and find out only one replicated table is involved, so just pick any idle partition to execute it?
What's the recommended way to write a stored procedure to query a single replicated table?
Thanks in advance.
-Xiang