Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
VFP COM slow to SQL7 through MTS
Message
De
25/06/1999 00:27:18
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Titre:
VFP COM slow to SQL7 through MTS
Divers
Thread ID:
00233828
Message ID:
00233828
Vues:
46
Hello all,

I have a component that is slow (~30 seconds) to do a simple two table insert and then SetComplete. When I view this with SQL Profiler, the 30 second bottleneck is on one line entitled SQLTransaction:DTL_Trans.
Everything else completes in less than one second. If I turn *Requires a Transaction* off on the component in MTS, it executes in less than one second.

I have been careful to SetComplete and cleanup all object references.

Ideas?...
Répondre
Fil
Voir

Click here to load this message in the networking platform