Home Dashboard Directory Help
Search

PDW - prevent table locking when Fast Appending records (allow selects) by Dave_Le


Status: 

Active


4
0
Sign in
to vote
Type: Suggestion
ID: 865034
Opened: 5/1/2014 11:19:51 AM
Access Restriction: Public
0
Workaround(s)
view

Description

right now fast append lock the destination table and prevent reads from it, in a situation when PDW is being used as a critical DWH (as it should) and being loaded with data every 30 sec (for example) fast append prevent selects and by doing that the users can see the newly inserted data - unlike SMP sql where the table data is available all the time.
Details
Sign in to post a comment.
Sign in to post a workaround.