topic Re: What's happening while opening Designer? in Qlik NPrinting

What's happening while opening Designer?

Danijel — Fri, 10 Mar 2017 14:03:32 GMT

Hello together,

some interesting point. In almost all cases the NPrinting Designer takes 3-5 Minutes while opening the designer.

Within the report is only one Table, no levels, charts..

What is he doing in the background? At Task Manager i can see CPU load about 15-25 % and RAM 200-300mb.

Some other Facts:

NPrinting Version 17.3

PixelPerfect Report

QlikView (12.1) Application (Connection local),

How is the speed with you?

Greetings

Re: What's happening while opening Designer?

Lech_Miszkiewicz — Mon, 13 Mar 2017 00:17:11 GMT

Hi, there is many factors you need to take into consideration.

QlikView applications size - NPrinting needs to open QlikView application when editing Pixel Perfect template. Given that you are using local connection - your application fully has to be loaded again to memory before NPrinting can start working on it. I suggest using server connection as this should work faster and smoother.
1. Size in MB or,
2. No of Rows/Colums in Fact table
3. btw. do you have any data island tables there?
What is a CPU on designer box? I noticed that Intel i5 were very slow with PixelPerfect designer - so slow that couple years back i have actualy raised support case and it turned out that my computer was just slow. I still think it was not right diagnose but on i7 everything was working much faster.
How many CPU cores do you have on designer box?
Pixel Perfect template - you are saying that there is only one table. Pixel Perfect table is actualy loaded as a level which can be bit slow. Is that what you meant, or there is only one table loaded under table metadata entity - but then how are you using it?

I know that work with Pixel Perfect templates can be very frustrating especialy when building complex multi-level reports with pictures, sparklines and pixel perfect charts which can be super super slow.

regards

Lech

Re: What's happening while opening Designer?

Danijel — Mon, 13 Mar 2017 09:40:04 GMT

Hey Lech,

thanks for your detailed answer.

I've tested it again with a "smaller" Application:

Regarding your questions:

1. Open the Designer over local Connection: 1:30min; over QVP: 1:25min. The Report has one Table with 5 columns.

About my test Application:

1.1: Size 219mb

1.2: 4 Tables with overall 2,9 mio Rows -> from that, Facts with 2 mio Rows; About 305 Objects..

1.3: No Data Islands..

2. CPU is a Intel Xeon E5-2630, 32 GB Ram

3. 6Cores

4. No, it isn't loaded as a Level. Is, how you write, the table is loaded under table metadata entity, and dragged from there to the Detail Area.

Greetings