Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Performance issues on QlikView - IIS or QVWS

We are quite new to QlikView. We are using QlikView 11.

We have a QVW on about 200Mb, with about 6.500.000 records.

We are a bit disappointed about performance on the the web app (Access Point). There is about 3-4 seconds on each click.

When I open the QVW directly on the server in QlikView Developer, it is very fast, but if I open the Access Point in Internet Explorer, also on the server, there is 3-4 seconds on each click.

We have installed QlikView server as a virtual server under VMWare. I know, QlikTech recommends a physical server, but I can also see here in QlikCommunity, that many of you are using virtual servers. And of course, it is a matter of price as we have all our servers in a hosting-center.

It is a fast server, with 64GB RAM allocated to this server - running Windows Server 2008 R2.

I can see, that you can use either QlikView own webserver QVWS or you can use IIS. We use QVWS.

Would there be any chance to improve performance with IIS ?

5 Replies
Highlighted
Partner
Partner

I haven't any experience in cases where IIS have improved the performance of an applications.

As the performance is good when opening directly on the server, the issue doesn't seem to be lack of CPU power, which otherwise could be the reason.

A more likely reason is that you need to open som ports which is causing the communication to be tunneled.

You can tjeck whether communication is tunneled by opening a session from the Access Point, and in another window log on to QMC, and see if any sessions i tunneled in the QMC Statistics/Performance tab. Look for TunneledDocSessions

Highlighted
Not applicable

Hello Jens

I am not sure, where you mean.

Do you mean, QMC - Status - QVS Statistic - Performance?

See statistics below.

Firewall Inbound Roules for QlikView server:

TCP

Local ports: 4747, 4774, 4720, 4750, 80, 4780, 4799, 4730, 4735

Remote Ports: all

Firewall Outbound Roules for QlikView:

TCP

Local ports: All

Remote ports: 80,4747

ExeType

RLS64

ExeVersion

11.0.11440.0409.10

Timestamp

2013-05-21 21:23:21

DocSessions

1

AnonymousDocSessions

0

TunneledDocSessions

0

DocSessionStartsSinceMidnight

1

RefDocs

1

LoadedDocs

2

IpAddrs

1

Users

1

CPULoad

1

VMCommitted

2435.519531

VMAllocated

2762.855469

VMFree

59114.558594

VMLargestFreeBlock

59114.558594

UsageCalBalance

-1.000000

TimeZoneBias

-120

GBytesOfRamConfigured

44.7996955868

NumberOfCores

4

RecentCpuPercent

1

RecentRamOverload

0

OffDuty

false

Unlicensed

false

Highlighted
Partner
Partner

Yes, that's it.

However, TunneledDocSessions = 0, so this wasn't the issue.

Do you experience the same bad performance regardsless if you use IE-plugin or AJAX?

Highlighted
Not applicable

I just tried to switch from AJAX to IE-plugin - and it seems much faster...

Highlighted
Not applicable

Lige en opfølgning på ovenstående.

Vi oplever ind imellem, at der i QMC at værdien på TunneledDocSessions er over 0.

Jeg kan se, hvilke brugere der er aktive under "Active Users" og jeg kan se TunneledDocSessions under Perfomance. Men jeg kan desværre ikke se, hvilke Active Users der har TunneledDocSessions, så jeg kan kontakte dem og tjekke opsætning.

Er der mulighed for at se, hvilke Active Users der har TunneledDocSessions ???