Hi all,

I have a VFP table with 11.9 million (1.4 GB file size) records and I created a view off it which has 87,000+ records. The source table has PK consisting four columns as such: bintoc(id1)+bintoc(id2)+bintoc(id3)+timeframe with a !DELETED() filter. It takes approximately two seconds or more to replace two columns of the view.

The performance is very acceptable (fast) with 2800+ records in the view. Source table is on a network location. Even when data (source table) is on local drive, performance does not improve at all.

Settings are as follow:
command:
replace nQty with m.Qty
if !isnull(m.Rev)
   replace nRev with m.Rev
endif

Buffering = 3 && optimistic row
WhereType = 3 && key & modified fields ; setting this to 1 slowed it down further

SYS(3050,1,15000000)
SYS(3050,2,10000000)

Pentium III-M 1.2M
Base Physical Memory 512 MB
Windows 2000 Pro SP3
VFP 7 SP 1

Any inputs greatly appreciated.