locked
How to stop discovery from adomd.net connection RRS feed

  • Question

  • I am using MSAS 2005 with ADOMD.NET 8.0 with .NET 1.1

    I observed whenver we execute any query it does discovery of meta data. The meta data is part of resultset that is returned to the client. You can see this part of XML that is returned to client.

    <root xmlns=\"urn:schemas-microsoft-com:xml-analysis:mddataset\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\"><xs:schema targetNamespace=\"urn:schemas-microsoft-com:xml-analysis:mddataset\" elementFormDefault=\"qualified\" xmlns=\"urn:schemas-microsoft-com:xml-analysis:mddataset\" xmlns:xs=\"http://www.w3.org/2001/XMLSchema\"><xs:complexType name=\"MemberType\"><xs:sequence><xs:any namespace=\"##targetNamespace\" minOccurs=\"0\" maxOccurs=\"unbounded\"...........Very long XML >
    <CellData><Cell CellOrdinal=\"0\"><Value>6/Value><FmtValue>6</FmtValue></Cell></CellData></root>

    So result is very small XML compare to long XML in its tail.

    This  causes poor  performance at client. How can we avoid discovery and return of meta information to client?

    Wednesday, May 24, 2006 10:28 PM

Answers

  • It is currently not possible to turn off this extra information sent by the server.

    Adomd.Net 9.0 (shipped with Analysis Services 2005 and available at http://www.microsoft.com/downloads/details.aspx?FamilyID=df0ba5aa-b4bd-4705-aa0a-b477ba72a9cb&DisplayLang=en) uses compression by default so this should significantly reduce an performance issues related to XML size.

    Thursday, May 25, 2006 11:36 PM
  • There is not currently a way to disable the metadata and Adomd.Net 8.0 does not support compression.

    This extra metadata may be of use to some client applications.  My experience is that generally the SlicersAxis is the biggest unexpected extra peice of metadata and it contains all slices that apply to the cellset - both explicit and implict.

    Friday, May 26, 2006 9:56 PM

All replies

  • It is currently not possible to turn off this extra information sent by the server.

    Adomd.Net 9.0 (shipped with Analysis Services 2005 and available at http://www.microsoft.com/downloads/details.aspx?FamilyID=df0ba5aa-b4bd-4705-aa0a-b477ba72a9cb&DisplayLang=en) uses compression by default so this should significantly reduce an performance issues related to XML size.

    Thursday, May 25, 2006 11:36 PM
  • We are not upgrading soon to version .NET 2.0 that are prerequisite for ADOMD 9.0.

     Is there way in current version to turn it off or use compression to reduce its size?

    What is reason Meta information passed to client with every call?

    Friday, May 26, 2006 1:18 PM
  • There is not currently a way to disable the metadata and Adomd.Net 8.0 does not support compression.

    This extra metadata may be of use to some client applications.  My experience is that generally the SlicersAxis is the biggest unexpected extra peice of metadata and it contains all slices that apply to the cellset - both explicit and implict.

    Friday, May 26, 2006 9:56 PM