on 02-22-2008 7:18 AM
Since we've upgraded from BW3.5 to BI 7.0, query performance deteriorated. The same query now runs longer in BI 7 than compared to in BW 3.5, especially for queries that return large sets of data.
For example, one query took 4 minutes 30 seconds in BW 3.5, but takes 10 minutes in BI 7.0
File size also increase from 6,500 Kb in BW 3.5 to 16,000 Kb in BI 7.0
I believe it takes longer to format the data after retrieval, and it was trying to plot 17,000 records on the the embeded chart. But after we've unhidden and deleted the chart, file size almost dropped half, to about 7,600 Kb.
I believe the embedded graph is a nice-to-have, but it all depends how the data is plotted to detgermine the meaningfulness of the grapah - which is not in most cases for us and hence the graph is not too measningful.
Does anyone know if there is a way to turn off / disable the auto pre-plotting of graph in BI 7?
I believe that this should improve query performance if it is disabled..
Many thanks for your help.
Lawrence
Just to add that: for smaller queries, the time and size dfference are not significant, but large queries are taking significantly longer (and larger in file size in BI 7)..
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
76 | |
10 | |
8 | |
8 | |
6 | |
6 | |
6 | |
5 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.