topic Re: Trigger performance help in QlikView

Trigger performance help

Anonymous — Thu, 19 Mar 2015 13:42:45 GMT

Hey guys

I'm having performance issues with all of my triggers

in my model each time I move from one sheet to another I have around 10 triggers, select in field that need to be selected

any ideas on how I can improve the performance?

Thanks

Re: Trigger performance help

Gysbert_Wassenaar — Thu, 19 Mar 2015 13:48:07 GMT

1. Don't use triggers.

2. Try to use bookmarks

3. Explains what you're trying to achieve. Why are you using triggers.

Re: Trigger performance help

Anonymous — Thu, 19 Mar 2015 13:52:32 GMT

i tried the bookmarks and it was much worse.

the requirement is that each time a user enters a sheet there are a few selections required

is there a difference on adding a trigger on sheet or on document, performance wise?

or maybe a macro would have better results ?

Re: Trigger performance help

Roop — Thu, 19 Mar 2015 15:11:37 GMT

Can you not use "Set Clear State" as your default state that is set when "Clear" is pressed. You would then just need 1 trigger on opening the sheet.

This would have the additional benefit of ensuring that the default state was selected when pressing "Clear" as well as making system quicker.

The "Set Clear State" is under the "Clear" drop down ....

Re: Trigger performance help

Gysbert_Wassenaar — Thu, 19 Mar 2015 18:10:09 GMT

the requirement is that each time a user enters a sheet there are a few selections required

That sounds like one bookmark per sheet and a Replace Bookmark action for the OnLeave Sheet trigger and an Activate Bookmark action for the OnActivate Sheet trigger. That should not impact performance significantly. If you do experience performance degradation you should analyse your document to find bottlenecks. You can use the Document Analyzer for this purpose.

Re: Trigger performance help

Anonymous — Fri, 20 Mar 2015 19:52:10 GMT

when I remove the triggers the performance is great

the proble are the triggers is there any other way to select in field besides bookmarks and triggers ??

Re: Trigger performance help

Gysbert_Wassenaar — Sat, 21 Mar 2015 07:28:14 GMT

The other way is to let the users decide which selections they like to use.

Your Select in Field actions can be costly, depending on how you construct your search strings. Bookmarks should be less costly. Well, that depends too. Perhaps you'll store complicated search strings in the bookmarks too.