Temporarily Disable Logging in Load Script

dwforest — Thu, 21 Jul 2022 23:27:10 GMT

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?

Re: Temporarily Disable Logging in Load Script

rubenmarin — Sat, 23 Jul 2022 07:29:43 GMT

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.

topic Re: Temporarily Disable Logging in Load Script in App Development

Temporarily Disable Logging in Load Script

Re: Temporarily Disable Logging in Load Script