>>>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.
>
>Thanks for the reply Nabil,
>
>I use surrogate keys exclusively and I never make the primary key index to be clustered, instead, most of time I reserve the clustered index for the 'real key'. If the clustered index is the point then I fail to undersatand why the inserting speed differs so greatly between a record with filled memo field and a record with a blank memo field. It is instant to insert for later case.
>
>Chen
As far as I know that if you add a record to a table with a clustered index, then this record will be placed immediatly in the correct sorting order.