Hello everyone,

I am developing a Mobile PWA that uses local storage, and I'm facing a challenge with synchronizing my local data back to the server.

Specifically, I have a local table that stores a GUID and a quantity. I want to update the corresponding record in the server table where the GUID matches. My concern is finding a performant way to handle this synchronization without using a For Each loop to iterate over the local list and updating each GUID on the server.

One approach I considered is sending a comma-separated list (e.g., key;value,key,value,...) to an advanced query. However, I'm concerned there may be limitations in terms of input size or in the SQL logic itself.

Any suggestions or recommendations would be greatly appreciated! Thank you!