Hello,
I am using ADOMD for fetching cube information from a .net application.
typical code sequence is open an conncetion with OLAP, make a query using
cellset object of ADOMD and close the olap connection .
Upon profiling the application I find that most of the time goes in
1. opening and closing the conncetion.
2. Calls to the retrieve operation CellSet.Get_Item(object[]) call to get
the cell object and calling on "Value" property of the cell

1. Do I need custom implementation for the Connection pool or Can I share
single conncetion among multiple retrieve calls ( are ADOMD calls are thread
safe)
2. How can I have faster way of retrieving values for the cells. ( Is
interop is performance killer here)

Thanks
Santosh

Hello Santosh,
1. use one connection. when you are opening a connection
to MSAS the PTS-Cache will be filled. Not every query is
going to be anwered by the server if the PTS-Cache already
got the value.
2. To query a cube use ADOMD.cset:
cset.Open "Select from Sales where measures.[store
sales]", PublicConn
myvalue = cset(0).Value

HTH
Jörg

Hello,
Thanks for the information .
Couple of more question.
1. Should I use one global connection and use the same conncetion in
multiple threads. Won;t there any be synchonising effects?
1. Can u please elaborate what is PTS-cache? Is there any upper limit for
this , will it not be useful to open as many conncetion is this cache allows
and pool them .. Any pointer to the documentation / sample implementation
would be very nice.
Regards,
Santosh
"joerg" <joerg.schmidt (AT) spamme (DOT) com> wrote

Hello Santosh,
1. use one connection. when you are opening a connection
to MSAS the PTS-Cache will be filled. Not every query is
going to be anwered by the server if the PTS-Cache already
got the value.
2. To query a cube use ADOMD.cset:
cset.Open "Select from Sales where measures.[store
sales]", PublicConn
myvalue = cset(0).Value

HTH
Jörg