Information générale
Titre:
VFP COM slow to SQL7 through MTS
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
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement