Opening the document too slow for a user

[ssanchez]

Hi there:

I have a document published on the server using about ten users and has a slow but acceptable performance, the document allows server objects. Only one user has significant performance problems in opening the document (3 minutes). Can user objects affect performance at the opening of the document? How can we analyze what causes loss of performance?

Thanks in advance

[Bill_Britt]

HI,

I would look at upgrading to a more current release of Qlik.

Bill

[ssanchez]

Thanks GandalfGray, we have already used that option but has no effect in this case.

[ssanchez]

Thanks Shane, the document is already preloaded into memory. I think the problem is the number and the performance of the user objects.

[IAMDV]

Hi Santiago,

Are there any "OnOpen" triggers/actions in the document? Also, I'd recommend having a simple landing page (Probably a textbox etc) instead of loading all the objects on the first screen. Also, go to "Sheet Properties" > "Objects" tab and check for "Calc Time".

Cheers,

DV

www.QlikShare.com

[ssanchez]

Thanks Bill, I'll remember. Unfortunately it is not possible at this time, too many documents in production. It should be the last option.

[gandalfgray]

What if you have all charts etc minimized as default?

[miikkaqlick]

Hi!

To my knowledge there isn't single tool that would give you bookmarks calculation time.

If that single user doesn't have too much server side objects, then you could do it by hand.

Br,

Miikka

[Bill_Britt]

Hi,

There are HTTP utilities out there that will show you load time of objects. You can even try the one built into IE.

http://msdn.microsoft.com/library/ie/bg182326(v=vs.85)

Look for  "The Network tool  (CTRL + 4)"

Bill

[ssanchez · Accepted solution]

Thanks to all for your answers. I solved the problem by removing the non-visible user-objects and optimized the visible user-objects manually, one by one. Hard work because the user had many items.

The problem was in the user objects (amount of objects and inefficient objects) but It's not easy to debug. and I have not found any official information on how user objects affect the performance of document Qlik.

Best regards