InaPlex Forums

Hi David,

I like the new logs files in & they give a lot more information. I have a question on the updates statistic.

I have a script with the option "Compare all fields and only write is they are differences". Do the statistics take this into account when it's counting the updates.

I ask the question  because I ran my script twice to see what happens and both logs were the same. I was expecting zero updates on the second run.

Hmmm...  Good point.

At the moment, the counting of inserts/updates is done at the "logical" table level, rather than the lower physical table level, in order to make it simpler. The logical level does not actually know if an update was cancelled because there was nothing to do. We'll have to address this.

There is also an "IO Logging" capability, which records the actual SQL issued at the physical level. Turn this on (Tools - Start IO Logging). You should see the second update substantially reduced or disappear.

NOTE: The IO Logging currently only works for SQL based targets such as CRM and SLX.

Regards

David