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.
Following these three observation, I am using a real dirty way to deal with the problem. On my form, if a new record is added, I issue tableupdate() when I detect that an user enters editbox (memo field), so that I am sure that I insert the record to the server without memo contents first. This is real dirty that some other issues may appear.
Chen
Chen Nan