MSXML to MSXML3 performance gains???

admin

Administrator
Staff member
Hello,I am finalizing the development of a distributedapplication written in VB 6.0 SP4, comprised of an EXE,one OCX, and 4 DLL's that uses XML for communicationbetween 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, DESCRIPTIONFROM PROFILES WHERE PKID = ???} AS PROFILES APPEND(( SHAPE {SELECT A.PKID,A.DESCRIPTION,PA.PKID AS FKEYID, PA.PROFILES_ID FROM AREAS AS A LEFTJOIN PROFILES_AREAS AS PA ON A.PKID =PA.AREAS_ID} AS AREAS_ASSC APPEND (( SHAPE {SELECTS.PKID,S.DESCRIPTION,PAS.PKID AS FKEYID, PAS.PROFILES_AREAS_IDFROM SWITCHBOARDITEMS AS S LEFT JOINPROFILES_AREAS_SWITCHBOARDITEMSAS PAS ON S.PKID =PAS.SWITCHBOARDITEMS_ID} AS SWITCHBOARD__ITEMS_FKEYAPPEND ({SELECT P.PKID, P.DESCRIPTION,PASP.PKID AS FKEYID,PASP.PROFILES_AREAS_SWITCHBOARDITEMS_ID FROM PERMISSIONSAS P LEFT JOIN PROFILES_AREAS_SWITCHBOARDITEMS_PERMISSIONSAS PASP ON P.PKID = PASP.PERMISSIONS_ID} AS PERMISSIONS_FKEYRELATE 'FKEYID'TO 'PROFILES_AREAS_SWITCHBOARDITEMS_ID') ASPERMISSIONS_FKEY)AS SWITCHBOARD__ITEMS_FKEY RELATE 'FKEYID'TO 'PROFILES_AREAS_ID') AS SWITCHBOARD__ITEMS_FKEY) ASAREAS_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 withIE 5.0. If I upgrade to the MSXML3 DLL would I have anyperformance gain as far speed is concerned. I am notusing any types of schemas, XPath or other featurescurrently, but I might in the near future. The onlyobject that I am using now is the DOMDocument andIXMLDOMNode.Does anyone have any experience or insight into the speedgains of document parsing between the two versions?What are my tradeoffs between leaving MSXML as the DLL orupgrading to MSXML3?Thank you in advance.Matt
 
Back
Top