>There's this table that seems really slow when inserting records in a particular screen over a network.
>
>It's VFP 6.0, network using Windows 2000 Server.
>
>The table has 70,000 records, has 7 indexes (type 'regular'). Doesn't have an index on DELETED(), about 70 deleted records. It's a detail table for a parent table. In the mentioned screen, they have a persitent relationship in the data environment.
>
>Any ideas?
>
>Thanks.
See if there is a difference if you temporarily disable antivirus software.
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)