>Hi,
>
>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)
>
>Thanks
Some ideas in my FAQ #8109 (Rushmore Optimization) might help. In this case: 1) Be sure you have an index on the parameter, 2) Be sure you
do not have an index on
deleted().
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)