Locally openend .qvw very slow

[Anonymous]

Hi all,

since about one week our main App behaves strange. Every thing you do (e.g. Open Script, Open Table Structure, Open Object Properties, Switch to another tab....) takes considerably more time than before. If you open the Task Manager you can see that the CPU goes to 100% at that time. RAM is about 20% so thats not an issue.

Have restarted the whole Server - still the same.

Facts:
- .qvw Size is about 460 MiB

- 11.2 SR 10

- Winodws Server 2008 R2 64 bit

- Data Model has one SynKey. This key has been there since the first start.

Can sombody help me?

edit: I have to say that its not always like that. Sometimes it behaves normal = fast.

[Bill_Britt]

Hi,

Have you downloaded 11.20 SR11 and tested it with that? If you look at the release notes you will see issue

59323 Performance degrade when opening document QV10 vs QV11.20

Bill

[Anonymous]

Hi Bill,

Tested it with SR10, SR11 and SR12.

Phil

edit:

What if I dont follow the official recommendation and stay with a multi-fact-table datamodel, if it works better for me?

Will i run into problems eventually?