I did a quick Google on this question but couldn't find anything. I have an application which reads through a text file and processes the lines into DB records, which I then store in a recordset object via .AddNew. After I've finished reading the entire file, I then commit the new records to the DB using .Update.

My concern is that said file may in some cases be on the ginormous side, perhaps up to several hundred thousand records. So I'm wondering whether there are any recommended practices, rules of thumb, whatever, as to how many records you should add to the recordset before doing the .Update? (I'm assuming that doing an .Update with every record is a bad idea wrt overall performance of the app.)