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?
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.
|||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?
|||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.
No comments:
Post a Comment