Hi everybody,
I need to update one field in one table and two fields in another table in a batch process. I can not specify criteria in advance to receive a small subset of data. So, I'm thinking, what is better:
retrieve data by small portions, say, 100 records. Make my updates, then save, then proceed. Or retrieve everything, do updates, then do one Save (commit). What do you think is the right approach in this situation?
Keep in mind that I'm using VFP native data for a time being, though I hope to migrate to SQL Server soon.
What would you suggest?
Thanks in advance.
If it's not broken, fix it until it is.
My Blog