SCAN COMMAND SLOW ON NOVEL/NT NETWORK VS LOCAL DRIVE

[peter]

I have the following code to update balances on a table of 1100 records.
Whe runing this form on a local drive it takes 1.2 seconds
when running this form on a network drive on NOVEL 4.11 it takes 32.3
seconds
when running this form on a network drive on NT 4.0 it takes 29.4 seconds
when running this from on a mapped local drive it takes 18.3 seconds
Is ther any network-specific codes to speed up this form across
a novel 4.11 or NT 40. network??
Are there any prefred network protocol (IPX, NETBUI,TCP/IP) that are
know to work better with PARADOX?

The code is as follow:

method assign_accu_bal()
var
tc tcursor
sumit number
tBegin, tEnd, tOpen Time
endvar
sumit=0
tBegin = Time()
; tc.dmattach("acc_bal.db")
tc.Open("acc_bal.db")
tc.edit()
topen=time()
tc.home()
scan tc FOR tc.Account# = page.ACCOUNT#.Value :
message() tc.recno()
tc."UPDATED_BAL" = sumit + tc."BALANCE"
sumit = tc."UPDATED_BAL"
endscan
tc.endedit()
tc.home() ;// added home to return to top of table before resync to
TCursor
dmresync("acc_bal.db",tc)
tc.close()
tEnd = Time()
Message("Begin("+STRING(tBegin) +") End("+STRING(tEnd)+") Scan Took : "
+ STRING(Number(tEnd - tBegin) / 1000) + " " + STRING(Number(topen -
tBegin) / 1000) )
endMethod

Thanks for any comments.

Pe...@blueoceanlines.com