>Janet,
>
>If you have SQL Server (and possibly other back ends, I really only know MS SQL Server) you need to run UPDATE STATISTICS on your tables periodically to keep the index information current. You may need to do that.
>
>You should check to see exactly what command(s) FoxPro is sending to the back-end. Most server databases have a feature that allows you to trace the commands the server receives. There may be something about the way your view is desinged that is causing the problem.
>
>>>Does the table have an index on the key field(s) you're using to update it?
>>>
>>>>It takes us at around 2 minutes to just update a single record edited on a sql view. Why is it so? The table contains 1 million records
>>Yes, it has. Why is it still like that?

Josh,

Thanks for the info regarding the index, we just index the wrong field but it is ok now. I've got the wrong information from my office mate. Anyway, Thanks a lot.