Performance estimation for a special QlikView case

[#1]

Hello,

Could you please give me an approximate time or performance estimation for the following case:

For a QlikView system that has10.000 users, 1 of the users would like to get a report which contains 5 attributes and 2 metrics and that is using 3 tables, each containing data of 5M.

Thanks in advance,

Ekim

[#2]

Hi Ekimaparc,

I believe it is hard to give any estimation without knowing the underlaying hardware...

cheers

Florian

[#3]

Hi Florian,

All technical information is as follows:

Technical Environment

• Database

• Oracle 11g - exadata - 1 TB warehouse (DWH), 1 TB summary warehouse (SWH)

• SQL Server - 5GB metadata (MD)

• Hardware

• DWH, SWH - Sun 4500s, Solaris, EMC

• App Server - Clustered Intel, Linux, EMC

• MicroStrategy, MD - Intel, Win 2000 Server

• Software

Torrent Orchestrate, Informatica, MicroStrategy, IIS

will that information be enough to make an estimation?

Cheers,

Ekim

[johnw]

I don't know how to make a quantitative estimate.

However, I'll guess less than a second based on experience with similar data volumes, at least to render the report itself. 15 million rows of data isn't that much data, the report sounds simple, and I'm guessing that your hardware is up to the task even though I know almost nothing about server hardware.

[#5]

10,000 users?

[#6]

Total number of users is approximately 10.000 but the concurrent number of users can be taken as max100.

[#7]

HI Ekim,

is your application already running? If so, what is the file size? Based on that you can do simpl estimations on RAM usage.

From my experience: The largest application I ever saw used about 11GB RAM and the response time with concurrent users was only few seconds for getting full data list. Aggraget objects were much faster of course.

cheers

Florian