Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
J
1. Don't use triggers.
2. Try to use bookmarks
3. Explains what you're trying to achieve. Why are you using triggers.
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 ?
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 ....
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.
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 ??
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.