Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Recently we have witnessed the performance getting worse and worse on Access Point. I'm looking for some input on the variables that we might be able manage on the 'front-end' to improve it. By performance, I mean that when a user enters the URL for Access Point, it can take a minute or more to present the dashboards.
Things we have considered possibly impacting the performance:
Something else? Has anyone else successfully dealt with thing kind of thing?
This turned out to be a configuration issue. We had the logs in our Access Point directory. As the logs grew, every time someone opened Access Point, all of the directories and subdirectories were being scanned to look for QVW files.
Once we moved the logs out of the Access Point directory, performance improved significantly.
We've not tackled it as a specific issue. Well, I guess in one case I sort of did, but it wasn't in Access Point configuration. One application was particularly slow to load due to having many years of data, but most users only needed to see the current year. So I created an extra QlikView with just the YTD data by doing a data reduction in Publisher. So most users can click on the application that's much faster to load. That's more of a workaround than a fix, though.
You might want to look at the loading process using a HTTP debugger. A pretty neat one that attaches well to IE / Firefox is HttpWatch (see screenshot). There's a free version available.
Another option would be a tool called Fiddler, which is another http debugger that lets you follow the loading process. I would then contact QlikView support (http://www.qlik.com/us/services/support) to see if they can help you sort things out.
This turned out to be a configuration issue. We had the logs in our Access Point directory. As the logs grew, every time someone opened Access Point, all of the directories and subdirectories were being scanned to look for QVW files.
Once we moved the logs out of the Access Point directory, performance improved significantly.