Grid control multiple record save - Forum - Rollbase - Progress Community

Grid control multiple record save

 Forum

Grid control multiple record save

This question is not answered

Hi,

We've just added to our application a grid control to enable a bulk edit on multiple records. But we are having a performance issue on Save because it seems that for each record in the list from the grid control a read/update operation is called. Is this the normal behaviour? We were expecting the Save to do just an Update call with the entire dataset.
We've tried this with both normal grid control and the revised one.

Rollbase version:5.2.0.0

Best regards,

Dora

All Replies
  • Yes, this is the expected behavior. GridControl is a complex construct that allows manipulating data in related records with ease, but the simplicity ends there. A related record is also a first class record in the system and has workflows, triggers associated with it that need to be processed.

    In a save request, one could have removed records, added new ones, modified existing ones, attach, detach. These are not trivial operations and hence cannot be achieved in a single update call to the database.

    If you are looking at modifying select fields on a related dataset, consider using Mass Update action after selecting all/some related records.

    If you can shed light on your usecase, we can possibly guide on what feature would be best suited for the job.


  • Basically we have multiple records related to a Customer object. The object has only logical fields and we would like the user to be able to do a view/edit on all records at the same time ( But each field can have different values). Also if for example the first column is selected all other should be checked as well. Only operations needed are Read and Update.
    If we can't do this with what's available in Rollbase, we were thinking of manually retrieving the data and using a kendo grid. Grid control is working ok, but we have some performance issues because for all the 15 records we have for example a different call is made.

    Best regards,

    Dora