Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Large Script tab lagging

I have a script tab that I have added a large amount of long formulas to. It equals about 75 pages when copied into a word document,

I have noticed sever lag and process time when trying to edit anything on this tab.

Does anyone know of a way to increase the memory that the script needs when working on it? It is becoming a huge pain to work on, and still have a lot of troubleshooting and edits to do to it.

It currently takes about 4 seconds from clicking on a word for it to be highlighted.

Tags (2)
11 Replies
mov
Esteemed Contributor III

Re: Large Script tab lagging

Marc,

Can you try to break this script tab in 50 or 100 smaller tabs?

Regards,

Michael

Not applicable

Re: Large Script tab lagging

All of these formulas are based off of a single resident loaded table. I thought Qlikview did not like to break single table loads up across scripts.

mov
Esteemed Contributor III

Re: Large Script tab lagging

Wow, quite a load!

I just tried - QV doesn't care, just don't break it in the middle of a field name :-)

Re: Large Script tab lagging

I assume there are a lot of redundant code - this could be write more compact through (include)-variables and loops and will improve beside the editor-speed the maintaining, perhaps also the load-execution.

- Marcus

fernando_tonial
Valued Contributor

Re: Re: Large Script tab lagging

Hi, You can put your script in txt file.

In script QlikView use the command include.

Ex.

$(Include=Script.txt);

For edit the script, in editor script File > Open External Script File...

Best Regards.

Tonial.

mov
Esteemed Contributor III

Re: Large Script tab lagging

Yes, keeping script in a separate file should be helpful by itself.

Not applicable

Re: Large Script tab lagging

I just tried this and while it does allow it when the script is reloading, if does not really recognize it for the syntax checker so all of the formulas are underlined with red and it does not allow me to use the smart function that changes the word color based on the function or field name, or lists functions based on what I type. This would cause editing be become faster based on performance but much slower due to always having to check if i did something right

Not applicable

Re: Large Script tab lagging

You are right there is probably a lot of redundant code, many formulas are referencing parts of other formulas. The code now is so complicated that I think finding and removing redundancies would take more work than dealing with the performance issue.

Not applicable

Re: Large Script tab lagging

I would do this, but then I do not have access to the smart scripting functions that show where the other side of a parenthesis is, or suggested functions, or field colors.

Community Browser