1. mike S
  2. PowerServer 2020 or older (Obsolete)
  3. Monday, 5 December 2022 18:13 PM UTC

If i have many rows in a datawindow/store that will get inserted/updated/deleted: 

It's not clear whether a datawindow/store update is a single round trip to the server, or if each row is its own roundtrip. 

the same question applies to PS 2022

 

I assume that datastores and datawindows work the same.

Accepted Answer
Armeen Mazda @Appeon Accepted Answer Pending Moderation
  1. Monday, 5 December 2022 18:16 PM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # Permalink

Each DataWindow/DataStore DB-related command is one roundtrip, e.g. DW.Retrieve(), DW.Update(), etc.  You can use the PowerServerLabel to group some of these: https://docs.appeon.com/ps2022/Grouping_server_calls.html

Comment
  1. mike S
  2. Monday, 5 December 2022 19:02 PM UTC
So regardless of the number of rows that will be updated in the datawindow, an update is a single roundtrip.



to be clear, you are saying this is a single roundtrip:



dw_1.setitem( 1, 'col1', 'value')

dw_1.setitem( 2, 'col1', 'value')

dw_1.setitem( 3, 'col1', 'value')

dw_1.update() //updates all 3 rows as a single roundtrip.





  1. Helpful
  1. Chris Pollach @Appeon
  2. Monday, 5 December 2022 19:57 PM UTC
Correct
  1. Helpful 1
There are no comments made yet.


There are replies in this question but you are not allowed to view the replies from this question.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.