Hi all,
We have an ASP web application that uses a VB component to execute MDX
query. The VB component connects to Microsft Analysis
Service using ADOMD api.

We are facing a problem, when two or more users are using the
application the MDX query execution is getting serialized. If two users
hit the same page, the query execution for second user doesn't start
until the query execution for the first user is over.

I checked using perfmon, the IIS is not queuing the request it is
showing 2 requests are being executed. Both the requests are running in
different thread.

I am not sure what is causing the cellset's open method to run
sequentially and not in parallel. Can anyone throw some light on this?

Thanks and Regards,
Hitesh

Hi,

I guess it could be associated with the used apartment model.
How do You open ADOMD connection?
What is Your apartment model?

Thanks,
Vladimir Chtepa

"hitesh" <hiteshkhatri (AT) gmail (DOT) com> schrieb im Newsbeitrag
news:1109835472.288780.274090 (AT) g14g2000cwa (DOT) googlegroups.com...

We are using VB6 dll project with Apartment Model. The connection is
not opened explicitly. We are passing mdx query and connection string
to cellset.open method.

I Also tried creating connection explicitly, assiging it to
ActiveConnection property of cellset and then calling cellset.open, but
still the problem remains.

Doesn't seem it's apartment model problem because I tried same thing
with .NET too and there it is showing me two different thread id when I
log System.AppDomain.GetCurrentThreadId()

Any further leads will be helpful.

Regards,
Hitesh

Hi Hitesh,

I have a middleware that uses ADOMD. I have experienced nearly the same
problem as You.
I can't reach pure multithread using of one ADOMD connection.
I create sure number of worker threads. Every worker create own connection
to AS using ADOMD.
These connections are used exlisive only from creator worker thread.
Then I use producer-consumer queue for query dispatching from any other
thread.

Regards,
Vladimir Chtepa

"hitesh" <hiteshkhatri (AT) gmail (DOT) com> schrieb im Newsbeitrag
news:1109911629.661187.204880 (AT) f14g2000cwb (DOT) googlegroups.com...