Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2011-06-09 05:42 AM

Reload performance optimising

Hi. I have a script that is calculation-heavy - it works out daily monthly balances based on daily movements. I am finding that when the script gets to the LOAD statement that does these calcs (using Peek()) only 1 of 16 cpu cores is being used on my monster server, and that only gets to about 6% during that load. Other parts of the same script clock-up to around 70%. Any ideas on optimising this? Thanks!

4,866 Views
0 Likes
2 Replies
erichshiino
Partner - Master
Partner - Master
‎2011-06-09 07:34 AM

Are you using QV 10?

This last version has been optimized to work with multiples cores during reload.

but I don't know if there is a difference for the peek function...

309 Views
0 Likes
Not applicable
‎2011-06-10 10:16 AM
Author

In response to erichshiino

Hi Erich

Thanks for the reply. I am running QV10 and I can see the CPU usgae spread accross all cores until certain points in the script.

Whenever I invoke Peek() to lookup a previous value in the load table only one CPU is used. The reload is taking more than 10 minutes, which I'm sure could be much much faster considering the server is practically asleep for most of the time.

I have tried various ideas. Could it be related to the 'Order By' clause? A previous post gave me that idea.I have tried ensuring that the input table is already sorted, but that had no meaningful effect.

Thanks,

309 Views
0 Likes