Hi Chen,

Wow. Your desciption is very close to mine. The only difference I can spot is that you said that it is fast to update and existing record - memo contents or not.

Chen, in your situation, what is the default value on your memo contents field(the sql table text field at the server).

Is it NULL? (Meaning does the field allow null values and have no default value) Or, do you have a default value for the field at the server?

If you have a default value, so that the server does not insert a NULL when the memo is not used, then you and I have the exact same problem.

Please let me know.

Thx for your input.

Scott Barker.

>Hi Scott,
>
>A few months ago I posted a similar question here, but did not get it sovled.
I have VFP5a (sp3) + SQL Server 6.5. Using remote view with a memo(text) field, I got these observation:
>
>1- It is slow to insert a new record with non-blank memo contents, to the point that I can see the intens hard disk activities for up to five minutes on the server.
>
>2- It is fast to insert a new record if the memo field is empty.
>3- It is fast to update an exsiting record with or without memo contents.
>

<< rest deleted >>