Are these both the same updates? Can you recreate it? One should be similar to another all things being equal. But if there is something happening on the server computer, or if you are doing an update to 100 records at one time, and only one record at another there will be differences.



>Hi,
> I have a foxpro application and use remote view to connect to the sql server ( client/server). Sometimes, when i update the data into the sql server, it takes only around 1 second but sometimes it take arounds 20- 30 seconds.
>
> Can anyone share some idea on this or do u have any oipinion when doing upgrade and insert.
>
>
>Thank you very much.
>
>regards,
>
>florence