Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Optimizing a SQL command
Message
De
13/09/2013 13:17:25
 
 
À
13/09/2013 11:29:14
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Versions des environnements
SQL Server:
SQL Server 2008
Application:
Web
Divers
Thread ID:
01583170
Message ID:
01583189
Vues:
59
This is related to the Task.Log field. When this field is included in the SQL command, it is slow. This field is a Varchar(MAX). For 43 records, it contains the log of the last process of each task and that can be somewhat be considerable like a few K for each. I still do not understand however how this can be a factor. I have the same on other tables and this does not affect. I believe this might be related to data corruption or else. This Task.Log field is updated every minute. So, basically, it replaces the old value with a new one. Can this really be a problem?
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform