Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP COM slow to SQL7 through MTS
Message
From
25/06/1999 00:27:18
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
VFP COM slow to SQL7 through MTS
Miscellaneous
Thread ID:
00233828
Message ID:
00233828
Views:
45
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
Map
View

Click here to load this message in the networking platform