Results 1 to 4 of 4

Thread: msxml to msxml3 performance gain???

  1. #1

    Thread Starter
    New Member
    Join Date
    Jun 2001
    Location
    Florida
    Posts
    3

    Question msxml to msxml3 performance gain???

    Hello,

    I am finalizing the development of a distributed
    application written in VB 6.0 SP4, comprised of an EXE,
    one OCX, and 4 DLL's that uses XML for communication
    between the components.

    Here is an example of one of the smallest documents:

    <STREAMDATA>
    <VERSION>GENERICFORM</VERSION>
    <DATA>
    <TABLE>REGIONS</TABLE>
    <SQL>SELECT PKID, CODE, [DESCRIPTION] FROM REGIONS</SQL>
    <HIDESEED></HIDESEED>
    <SEEDVALUE>4</SEEDVALUE>
    </DATA>
    </STREAMDATA>

    Here is an example of one of the larger documents:

    <STREAMDATA>
    <VERSION>HIERFORM</VERSION>
    <DATA>
    <TABLENAME>PROFILES</TABLENAME>
    <GENERALSQL>
    SELECT PKID, PROFILENAME, DESCRIPTION FROM PROFILES
    </GENERALSQL>
    <HIERARCHYSQL>
    SHAPE {SELECT PKID, DESCRIPTION
    FROM PROFILES WHERE PKID = ???} AS PROFILES APPEND
    (( SHAPE {SELECT A.PKID,A.DESCRIPTION,
    PA.PKID AS FKEYID, PA.PROFILES_ID FROM AREAS AS A LEFT
    JOIN PROFILES_AREAS AS PA ON A.PKID =
    PA.AREAS_ID} AS AREAS_ASSC APPEND (( SHAPE {SELECT
    S.PKID,S.DESCRIPTION,
    PAS.PKID AS FKEYID, PAS.PROFILES_AREAS_ID
    FROM SWITCHBOARDITEMS AS S LEFT JOIN
    PROFILES_AREAS_SWITCHBOARDITEMS
    AS PAS ON S.PKID =
    PAS.SWITCHBOARDITEMS_ID} AS SWITCHBOARD__ITEMS_FKEY
    APPEND ({SELECT P.PKID, P.DESCRIPTION,
    PASP.PKID AS FKEYID,
    PASP.PROFILES_AREAS_SWITCHBOARDITEMS_ID FROM PERMISSIONS
    AS P LEFT JOIN PROFILES_AREAS_SWITCHBOARDITEMS_PERMISSIONS

    AS PASP ON P.PKID = PASP.PERMISSIONS_ID} AS PERMISSIONS_FKEY
    RELATE 'FKEYID'
    TO 'PROFILES_AREAS_SWITCHBOARDITEMS_ID') AS
    PERMISSIONS_FKEY)
    AS SWITCHBOARD__ITEMS_FKEY RELATE 'FKEYID'
    TO 'PROFILES_AREAS_ID') AS SWITCHBOARD__ITEMS_FKEY) AS
    AREAS_ASSC RELATE 'PKID' TO 'PROFILES_ID')
    AS AREAS_ASSC
    </HIERARCHYSQL>
    <HIDESEED></HIDESEED>
    <SEEDVALUE>5</SEEDVALUE>
    </DATA>
    </STREAMDATA>

    My question is this.

    I am currently using the MSXML DLL that was installed with
    IE 5.0. If I upgrade to the MSXML3 DLL would I have any
    performance gain as far speed is concerned. I am not
    using any types of schemas, XPath or other features
    currently, but I might in the near future. The only
    object that I am using now is the DOMDocument and
    IXMLDOMNode.

    Does anyone have any experience or insight into the speed
    gains of document parsing between the two versions?

    What are my tradeoffs between leaving MSXML as the DLL or
    upgrading to MSXML3?

    Thank you in advance.
    Matt


  2. #2
    scoutt
    Guest
    well you can look at it this way, it might have better security.

    I don't have experience with this though, I would think that any update to a program (dll) it would be better. also you have to think if the user has it or not. just a thought

  3. #3
    Banished Cander's Avatar
    Join Date
    Dec 2000
    Location
    Why do you care?
    Posts
    6,913
    In my experience there was no noticable speed gain.
    Stack Overflow
    See the features of Visual Studio 2010 and C# 4.0: The 10-4 show on Channel9

  4. #4
    PowerPoster sail3005's Avatar
    Join Date
    Oct 2000
    Location
    Chicago, IL, USA
    Posts
    2,340
    but like scoutt said, you might as well upgrade, becuase most of those kind of those updates are for security patches and stuff, not for performance gains.. What is stopping you from upgrading?

    USAUSAUSAUSAUSAUSAUSAUSAUSAUSAUSAUSAUSA
    USAUSAUSAUSAUSAUSAUSAUSAUSAUSAUSAUSAUSA
    USAUSAUSAUSAUSAUSAUSAUSAUSAUSAUSAUSAUSA
    USAUSAUSAUSAUSAUSAUSAUSAUSAUSAUSAUSAUSA
    USAUSAUSAUSAUSAUSAUSAUSAUSAUSAUSAUSAUSA
    USAUSAUSAUSAUSAUSAUSAUSAUSAUSAUSAUSAUSA
    USAUSAUSAUSAUSAUSAUSAUSAUSAUSAUSAUSAUSA
    USAUSAUSAUSAUSAUSAUSAUSAUSAUSAUSAUSAUSA
    USAUSAUSAUSAUSAUSAUSAUSAUSAUSAUSAUSAUSA
    USAUSAUSAUSAUSAUSAUSAUSAUSAUSAUSAUSAUSA
    USAUSAUSAUSAUSAUSAUSAUSAUSAUSAUSAUSAUSA
    USAUSAUSAUSAUSAUSAUSAUSAUSAUSAUSAUSAUSA
    USAUSAUSAUSAUSAUSAUSAUSAUSAUSAUSAUSAUSA

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width