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.