Skip to Content
0
Former Member
Jun 14, 2009 at 08:29 AM

3.x query performance on upgraded BI 7.0 - worse than before upgrade?

24 Views

Dear Sirs,

upgraded a BI system this weekend from 3.x to 7.0. Purely technical upgrade so no upgrade to 7.0 queries yet.

What we have seen is that queries with "loose"/lagre selection ? (e.g all plant .. all months) etc have worse performance than before upgrade.

One example: a query went from 26second to 60 seconds to run.

Small selection (e.g one specific plant and date) is same run time.

Has anyone had similar experience?

Is BI 7.0 optimized for 7.0 queries, or are there any performance parameteres I could look at.

Best regards,

Jørgen