Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Dynamic SQL query in a cursor
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Divers
Thread ID:
00485420
Message ID:
00486468
Vues:
16
>I don't see anything obvious. If it works and the performance is acceptable, go with it.

Actually I just found that performance is lower than what I have with VB and I don't understand why!

Performance was acceptable in my tests because I was always querying for the same table (@NomTable) and the same field (@NomChamp). As soon as I give other field, performance is not acceptable (25 to 30 seconds to process 240 rows).
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform