on 11-22-2011 12:10 PM
hello,
i got this questiom
I want to know about perfomance... what is better?
Lets think this scenario: if I have a query which want to compare data 2009 and 2010 (lets imagine they have more and less same records (forget about aggregate)
which is the best way?
a) MB : Infocube 2008 + Infocube 2009 + Infocube 2010
or
b) MB: Infocube 2008 + Infocube (2009+2010) //
the option b) its best way to select to database? because its just doing one select .. else a) two selects.
so, which would be the best approach a) or b) and why?
thx
Hi
InfoCubes with exactly the same characteristics and key figures, where one InfoCube contains the data for 2001, for example, and a second InfoCube contains data for 2002 are called as Homogenous Multiproviders. Homogenous MultiProviders can be used to partition on the modeling level of the InfoProvider.
If you want to improve the performance of a query for a MultiProvider, you can firstly check how the sub-queries are processed.
Execute the query via the query monitor (transaction RSRT) with the option Execute + Debug. Choose the MultiProvider Explain option. You can see messages in the upper part of the screen that displays the query result.
A query based on a MultiProvider is divided internally into sub-queries. A sub-query is generated for each InfoProvider associated with the MultiProvider.By default, the existing subqueries are processed in parallel.
Use RSRT to execute the query with the Execute + Debug option. Choose the MultiProvider Explain option. The upper area of the screen, on which the query result is displayed, contains messages on how the query has been divided.
In your Scenario, it is better to have two cubes as the subqueries are processed in parallel and both require one DB select.
And after select the data need not be filtered thus reducing one step for processing.
Hope this helps,
Aparna Duvvuri
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
The performance will depend on various factor if the infoprovider is multiprovider , then the various factor may include as follows
1) The No. of work process allocated to it.: The more work process allocated , the faster the query is
2)The amount of data present in the infoprovider.
U can trace the runtime of the query processing.
Thanx & Regards,
RaviChandra
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
second one is not possible use multi provider or info set ok.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Use option "A", and create multiprovider on top of thease three Cubes.
It's useful for maintaince as well as for Performance.
Regards,
Sushant
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
10 | |
10 | |
9 | |
7 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.