have 2 related questions:
is it possible to work (primary editing) with the cached data (do I
need to set retrieve all data before manipulation?) and then post all
data to the DB (is it possible with the DSQL component insert dataset
data with the one call or there is a loop needed?); are client
datasets slower solution?

I have situation, that I need to work with the small amounts of data,
but without lag - working speed is the top criteria as timing for some
operations would be very tight (delaying would mean breaking schedule)