Extended Stored Procedure Questions

  • Hi,

    I have few questions about extended stored procedures, that hope someone on here could help me with.

    1. How well to calls from xp's to com dll's perform in general ?

    2. Is it possible to call MTS/COM+ components from xp's, ideally I want to be able to call a single instance of a component which holds lots of cached data, rather than load this data every time. Is this possible ?

    Thanks in advance.

    Andy

  • Hi Andy,

    Calls to COM objects can and do work extremely well. If you are using C++ make sure you deallocate and free your com resources systematically, otherwise you will cause yourself some serious issues.

    Also you should allocate and deallocate your resources per xp and not make your allocations global.

    Yukon is a completely different ball game, with managed code.

    Regards

    Douglas Chrystall

    Imceda Software

    http://www.imceda.com

     

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply