General information
Title:
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?...
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only