>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
>Josh
>We've tried doing it in just a few records and it reflect on the source table in just a few seconds. Is there any functions or buttons we need to set it up in order to let be efficient? Or is it the limitation of foxpro?