>VFP 5.0a + SP3 + SQL Server 6.5
>
>I must have done something very wrong. A remote view with a memo field and a few other fields. If I add a new record with the memo field filled, it takes some 5 minutes to TABLEUPDATE() and I can see the intens hard disk activity of the server. However:
>1) If I add a new record leaving the memo field blank, it is fast.
>2) If I edit an exsiting record with or without memo contents, it is fast.
>
>Chen


If your table is dynamic, then your primary key index should be Non Clustered.
If your table is Static (such as reference Tables) then your primary key index should be Clustered.