>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.
>
>Kevin

Table has primary key wich is used in where clause for update (where clause only by key field); no order by; 3 parameter for where 1 of them has index.
Slow working is only for sending sql update not for viewing data (requery).

Doru