Remove repetitive file writes

While inside a loop, such as from an SQL read or IOS query, designers commonly place a File Access node in the process to write out each record from the query to a file. Disk input/output (I/O) negatively impacts performance, so when possible, remove these repetitive file writes with a Message Builder node inside the loop. By doing so, you will be appending all your records to a String in memory which is much faster than writing it out to disk. At the end of the loop, place one File Access node in your process that writes all of the Message Builder node output to a file at once.