I have a fairly straightforward application that has a remote view
that I use to read/write to a remote MS-SQL server. The foxpro app is
written in V8, and the SQL server is V6.

My problem is that from across the network (of our WAN) insert times
for a single record measure between 4.5 to 6.5 seconds. Updates, and
deletions take less than a second each. From the LAN the times are
measured in the 100's to 10's of seconds.


Although I'm not sure, the problem seems to get worse as the database
grows (currently its at only 15,000 records).
Does SQL send back the complete changed viewed upon an insert? Has
anyone seen this and/or know how to fix this speed issue?

Thanks,

Psavelli