Hello all,
We have set up new environments and write to data store in to a table having PK and 4 columns it self takes 1.34 second which seems to be too high .
Issue we are facing with the other nodes which is inserting more data and time is at higher end which is impacting the perfomance and response time of the process.
Is there any possibilty to update some configuration or setting at server side so that write to data store takes lesser time ? Usually write to data store should not take time in seconds to just insert 4 columns .
Any pointer will be helpful .
We have on-premises env whihc is newly setup .
Thanks in advance,
Pooja
Discussion posts and replies are publicly visible
agree with the comments
1. this is expected when not chained, due to prioritization -- and you should not chain just to speed it up
2. is this happening in a wizard like UX -- if not, then it should not impact the user and you can mark records 'in progress' to be hidden via default filters, locked, or tagged that in progress
but also
3. check to see what triggers or checks you have on the table within your db that could increase the time -- outside of Appian's control