Re: Pivot Service

From: stevo (intapplications_at_hotmail.com)
Date: 03/30/04 

Date: Tue, 30 Mar 2004 20:29:29 +1000

Hi Maersa,

To the best of my knowledge, PTS is definitely at the bottomn of the
communications stack when talking to AS, even when using XMLA. XMLA is
basically a web service wrapper written around PTS (I'm not oversimplifying
here am I Akshai? :-) ).

You can always cache data on the 'client' end (ie the caller of the web
service), otherwise XMLA will cache some amount of data, but if you're not
using sessions, you may not see any benefit.

"Maersa" <ma_ersa@hotmail.com> wrote in message
news:ub$0LDiFEHA.624@TK2MSFTNGP10.phx.gbl...
> Hi,
>
> So since we talk to the webservice XML/A the pivot services doesn't come
> into play here i guess. So are there some good caching techniques that can
> be used when reading from large cubes ? does xml/a have support for some
of
> this stuff or do we need to manage this ourselves.
>
> thanks,
>
>

Relevant Pages

  • Re: Pivot Service
    ... the XMLA SDK will instantiate PTS connections to the server. ...
    (microsoft.public.data.xmlanalysis)
  • Re: Pivot Service
    ... basically XMLA provides connection pooling and web service ... functionality on top of PTS. ... XMLA itself doesn't do any caching, ...
    (microsoft.public.data.xmlanalysis)
  • Re: Pivot Service
    ... my client machine I talk to XML/A. ... Does this mean that on the server machine PTS is already running? ... XMLA itself doesn't do any caching, ...
    (microsoft.public.data.xmlanalysis)
  • Re: Bad performance for MDX query over XMLA
    ... XMLA is not going to be as performant compared with a native binary ... Just the size of the response alone is going to be much larger ... > My query is retrieving a large number of facts accross 5 members ... > When I run the query over PTS I get a reponse within 30 sec. ...
    (microsoft.public.data.xmlanalysis)
  • Bad performance for MDX query over XMLA
    ... I'm experiencing serious performances issue when using XMLA 1.1 SDK on ... My query is retrieving a large number of facts accross 5 members ... When I run the query over PTS I get a reponse within 30 sec. ...
    (microsoft.public.data.xmlanalysis)