Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Performance issues when updating
Message
From
14/12/2000 12:50:14
 
 
To
14/12/2000 11:15:57
General information
Forum:
Microsoft SQL Server
Category:
Other
Miscellaneous
Thread ID:
00453416
Message ID:
00453482
Views:
20
Yes, SQL Server is logging the changes that your making and NO, you cannot bypass the logging.

Use the SQL Server Profiler to determine the number of trips VFP is making to the server. I seem to remember a property that would control the number of commands sent back to the server in a trip (BatchSize maybe??) Also, for every update that you make, the indexes must be adjusted. Try to avoid updating the PK, especially since you mentioned that it's clustered.

-Mike
Michael Levy
MCSD, MCDBA
ma_levy@hotmail.com
Previous
Reply
Map
View

Click here to load this message in the networking platform