Reload performance optimising

[#1]

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!

[erichshiino]

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...

[#3]

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,