datatstore question - linked to editing a table tut

[Sean]

I need to understand the logic behind this and any clarification would be most welcome.

I haven't delved deep enough and don't have a full understanding of the methodoligies used so I am going to ask a couple of questions and hopefully some kind soul will enlighten me.

1) When using a datastore + remoting connector as with the editing a table tut for example, is every record from the db pulled into the dataSet ?
+ could this not potentially cause the app to run slowly if you have say 1000 records ?

2) when updating a db through a dataSet and amfphp as in the editing a table example if you edit one entry, is the entire db rewritten or is only the entry that has been changed/updated written back to the db ?



If the above answers are true and false what is the best methodology to use to browse/traverse 100's potentiall 1000's of records in a db through flash, edit your desired records and only update the entry that has been altered ?


Any help would be most welcome !

Thanks
Sean./

[Jorge Solis]

1 Yes, if your table is large, you need to use the setDelivery mode to some pageSize, and move forward-backward to see and download just a subset of your records.
2 In the example, the whole recordset is sended. Probably you want to build an array with just modified data to send to the server, or use deltaPackets with the RDBMSResolver component

Jorge