Hi,

I am using ADOMD.NET to connect to a datacube over TCP/IP and am
experiencing very poor performance.

The MDX query I am running returns a single measure, however it can
take up to 4 seconds to execute.

Upon inspection of the TCP/IP packets that my web server receives, I
notice that there is extraneous data in the result set. I get
information on dimensions that I didn't ask for, as I only asked for
one result.

Can anyone offer some advice as to why this is happening and what I can
do about it?

Hi,

What a MDX query do you run?
What version do you use AS2000 or AS2005?
What shows Profiler? (If you have the AS2005)

Vladimir Chtepa.

"jsco" <jenscobie (AT) gmail (DOT) com> wrote

Hi,

I am using the following query:
SELECT {[Measures].Members} ON COLUMNS FROM AgencyListing WHERE
([Agency].[<id>]), which returns the one value. Similiarly, the cellset
that I create to read out the info only contains the one measure. It's
just the packets that contain extra information about the agency.

I am running AS2000, so I just used a packet sniffer to inspect the
messages I was receiving from my analysis server

Cheers,
Jen

have you some calculated measures defined? (if yes, what are the formulas)
what is your connection string?
what is your client tool?


"jsco" <jenscobie (AT) gmail (DOT) com> wrote

Hi,

I don't have any calculated measures defined at the moment.

Connection string is: Provider=MSOLAP.2;Client Cache Size=0;Data
Source=<server name>;Auto Synch Period=10000;Initial Catalog=<cube
name>;ConnectTo=8.0;Transport Compression=None;Protocol
Format=XML;Execution Location=3;Default Isolation Mode=1
Everything after Transport Compression was used to allow me to inspect
the information that my AS server sends to my web server.

I am using ADOMD.NET in a C# ASP.NET web application.

Cheers,
Jen

have you try different connection string?
Like:
Provider=MSOLAP.2;Client Cache Size=25;Data Source=<server name>;Auto Synch
Period=10000;Initial Catalog=<cube name>;ConnectTo=8.0;Cache Policy=7

The Compression is not used when you access an AS2000 cube, this is an
AS2005 feature.

what's appends when the query is like this:
SELECT {[Measures].Members} ON COLUMNS ,
{[Agency].[<id>]} on rows
FROM AgencyListing



"jsco" <jenscobie (AT) gmail (DOT) com> wrote

I tried the new connection string, but it seems the addition of Cache
Policy=7 throws an exception:

Unable to recognize the requested property ID 'DbpropMsmdCachePolicy'.

I also tried the query you suggested, but still received extra
information.

Has no one else had performance issues using adomd.net and connecting
to an analysis server over TCP/IP?

normally over TCP/IP the performance is good.
over HTTP there is an overhead (which is going through IIS)

"jsco" <jenscobie (AT) gmail (DOT) com> wrote

Thanks for your help - I'm going to give reporting services a go