We need to look up data from specific elements (2000+) from within an automation script.
By doing this with the existing c# / engine methods we noticed load peaks in SLDataGateway on the agent that is executing the script.
Since the number of elements will only grow (across a cluster), we fear this load will also increase on the agent running the lookup.
Is there a way to collect specific element param (cell) data directly from the database instead of using
- FindElementsByProtocol (2000+ matches)
- GetParameter
- GetTableDisplayKeys
Hi Mieke,
I’m not aware of a way to retrieve this data directly from the database. That would also depend on the type of database being used.
Instead of retrieving the table cells one by one, you could try to use the DmsTable.GetData() method. This method retrieves the full table at once, and should cause less load on the system.