>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?
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only