I run this VFP6 app for couple of years w/o a real performance issue. Server Novell 5.1, workstation XP Pro, 98SE. Now I exeprience an on and off performance issue and I need to rule out any foxpro fault. The following code takes seconds to move to the next record.
sele a_armord
set orde to io
seek m.xio
do while io=m.xio .and. .not. eof()
if rlock()
repl actqty with actqty+1
unlock
endif
skip
enddo
The table has about 40k records with 231 fields and 5000 characters per records.
sele a_armord
set orde to io
seek m.xio
do while io=m.xio .and. .not. eof()
if rlock()
repl actqty with actqty+1
unlock
endif
skip
enddo
The table has about 40k records with 231 fields and 5000 characters per records.