I have a 34MB table wich are updated by a local view in form. The view prezent ~10 records from a 400000 records table. After modify 1-3 records and issue a Tableupdate() proces take ~10 to 20 seconds on a Celeron 1000 with 196MB and 100Mb network (Network is not heavy used by others). Why view are so slow? Do not use Rushmore? (even a seek and replace will be much faster)
If it is a parameterized view (or not) make sure you have indexes for the DBF on each parameter item , the order by field and the key field. This may help.