Have a section in a Load script that loops through the records updating some fields based on prior values (not necessarily the 1 previous) based on various logic of other field values.
Because the loop adds a record to a result set, it logs a message for each record added (something like):
DV << a368590e-67dc-4e1b-973c-1875f6136490
Lines fetched: 1
DV << a368590e-67dc-4e1b-973c-1875f6136490
Lines fetched: 2
DV << a368590e-67dc-4e1b-973c-1875f6136490
Lines fetched: 3
There are over a hundred thousand records so this takes over an hour and disabling the logging may? increase the performance. (Re-writing to remove the loop would be best, but time is limited)
Is there a script command to set or disable the logging?
Hi, So far I know there is no option to disable logs by script command.
In my experience to optimize loops, it's more importan check what it's doing in each iteration an try to optimize that task, in example, if it does a resident load, break the load in smallest portions and always do an optimized load when loading from qvds.
