Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Performance issues when updating
Message
De
14/12/2000 12:50:14
 
 
À
14/12/2000 11:15:57
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Divers
Thread ID:
00453416
Message ID:
00453482
Vues:
21
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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform