>> MTS packages have a setting on them to determine how long they remain in memory after execution is complete. Any subsequent requests for service from a front end will use the version in memory, not launch a new instance. The default for this setting is 3 minutes, but I have packages set for as high as 15 minutes.
>> It is not hard to tell when an instance is being created, and when one already exists. But, there is still only a half second or so delay.
>>
>>HTH
>
>Thanks, Wayne. I'll reread the paper with that insight.
>
>I take it you are fairly happy with the MTS approach...
>
>Peter
We have no problems at all... I can send an XML data set with 2000+ records/several cloumns instantly.
HTH
Wayne Myers, MCSD
Senior Consultant
Forte' Incorporated
"The only things you can take to heaven are those which you give away" Author Unknown