Network Speed and IT Guys

That your runs so much faster means there are RI Updates going on. ie When you update one record it updates a whole lot of child records. Turning off the transaction may possibly cause problems if there’s a crash in the middle of updating, your stuff will only be half done and it can be really hard to figure out whats what.

Also are you using TPS or DAT files? TPS usually goes faster with transactions, DAT Slower.

1 Like