I have a process I'm developing that spends a lot of time searching a collection for results. The collection has about 120 items (string is the key I'm searching for). Based on my test results, the loop is spending anywhere from 5-7 seconds searching for a match. This is easily 90% of time per iteration.
Does Blue Prism have anything like a hash or dictionary search? Right now, I have a loop for the collection and a conditional to see if the strings match.
I created a "cache" to try to help speed things up - if it finds a match, it adds it to a cache collection. The search hits the cache first - if not found, it then goes to the full collection. For what I'm doing, the cache does help as a lot of the same entries are repeated. (I am storing a key name along with an integer. The integer represents the number of down arrow presses are required to access an entry in the application we are trying to automate. This is kind of ugly, but its the only way I have found to select an item in the drop down box.)
I'm contemplating moving the collection data to a database and making a web service available to my process. I think this would be faster than what I'm doing now - even if it is 2-3 seconds, that is a nice speed improvement over what I have now. Other advantages would be data outside of my process. The data does not change frequently, but there will be changes over time.
Thanks in advance for any ideas on a faster way to search collections in Blue Prism.
Does Blue Prism have anything like a hash or dictionary search? Right now, I have a loop for the collection and a conditional to see if the strings match.
I created a "cache" to try to help speed things up - if it finds a match, it adds it to a cache collection. The search hits the cache first - if not found, it then goes to the full collection. For what I'm doing, the cache does help as a lot of the same entries are repeated. (I am storing a key name along with an integer. The integer represents the number of down arrow presses are required to access an entry in the application we are trying to automate. This is kind of ugly, but its the only way I have found to select an item in the drop down box.)
I'm contemplating moving the collection data to a database and making a web service available to my process. I think this would be faster than what I'm doing now - even if it is 2-3 seconds, that is a nice speed improvement over what I have now. Other advantages would be data outside of my process. The data does not change frequently, but there will be changes over time.
Thanks in advance for any ideas on a faster way to search collections in Blue Prism.