Skip to content
DataMiner DoJo

More results...

Generic selectors
Exact matches only
Search in title
Search in content
Post Type Selectors
Search in posts
Search in pages
Search in posts
Search in pages
Log in
Menu
  • Blog
  • Questions
  • Learning
    • E-learning Courses
    • Open Classroom Training
    • Certification
      • DataMiner Fundamentals
      • DataMiner Configurator
      • DataMiner Automation
      • Scripts & Connectors Developer: HTTP Basics
      • Scripts & Connectors Developer: SNMP Basics
      • Visual Overview – Level 1
      • Verify a certificate
    • Tutorials
    • Video Library
    • Books We Like
    • >> Go to DataMiner Docs
  • Expert Center
    • Solutions & Use Cases
      • Solutions
      • Use Case Library
    • Markets & Industries
      • Media production
      • Government & defense
      • Content distribution
      • Service providers
      • Partners
      • OSS/BSS
    • DataMiner Insights
      • Security
      • Integration Studio
      • System Architecture
      • DataMiner Releases & Updates
      • DataMiner Apps
    • Agile
      • Agile Webspace
      • Everything Agile
        • The Agile Manifesto
        • Best Practices
        • Retro Recipes
      • Methodologies
        • The Scrum Framework
        • Kanban
        • Extreme Programming
      • Roles
        • The Product Owner
        • The Agile Coach
        • The Quality & UX Coach (QX)
    • DataMiner DevOps Professional Program
  • Downloads
  • More
    • Feature Suggestions
    • Climb the leaderboard!
    • Swag Shop
    • Contact
      • General Inquiries
      • DataMiner DevOps Support
      • Commercial Requests
    • Global Feedback Survey
  • PARTNERS
    • All Partners
    • Technology Partners
    • Strategic Partner Program
    • Deal Registration
  • >> Go to dataminer.services

What Factors Affect The Time An Automation Scripts Takes To Complete

Solved1.25K views27th March 2023Automation script class library
2
Geovanny Galeano [SLC] [DevOps Advocate]725 21st July 2022 1 Comment

When running simple code from an automation to retrieve data from different elements. We are getting significant different results for the execution time, we are trying to identify what factors could be affecting this.

var iDms = engine.GetDms();
var element = iDms.GetElement(new DmsElementId(dmaId, elementId));

var sourcesTable = element.GetTable(3000);
var sourcesData = sourcesTable.GetData();

var destinationsTable = element.GetTable(4000);
var destinationsData = destinationsTable.GetData();

watch.Stop();

engine.GenerateInformation("@@@@ Done getting the data. Time spent: " + watch.ElapsedMilliseconds + " number of inputs retrieved: " + sourcesData.Count + " Outputs: " + destinationsData.Count);

For example when running the code above on element A we get this result

@@@@ Done getting the data. Time spent: 3291 number of inputs retrieved: 2560 Outputs: 1536 (Script 'TestTemp')

For element B which is a smaller element and therefore in theory should take less time to get the data the opposite is happening.

@@@@ Done getting the data. Time spent: 20152 number of inputs retrieved: 1024 Outputs: 512 (Script 'TestTemp')

Both elements are on the same DMA which is part of a cluster. So going from 3 seconds to 20 that's almost 7x difference. Apart from the size of the data getting retrieved, what other factors could be affecting the execution time?

Geovanny Galeano [SLC] [DevOps Advocate] Selected answer as best 27th March 2023
Alberto De Luca [DevOps Enabler] commented 21st July 2022

Where the data actually resides can play a significant part … e.g. polling data from another DMA with a different local DB – with a cassandra cluster, I’d expect time to go down, but haven’t tried this – will tune to see wat comes from the community – the state of the DB, performance of the other server, SSD drives, it all comes into play from what I’ve seen so far – but 3 to 20s isn’t a big deal from my pov – as long as there is no timeout, I’d be fine if my query gets the results without stressing too much the DMAs- I understand GQI is the new preferred way as it should allow to structure the query in an efficient way – but I’m too new to it – so waiting some more experienced members in the dojo

2 Answers

  • Active
  • Voted
  • Newest
  • Oldest
0
Geovanny Galeano [SLC] [DevOps Advocate]725 Posted 27th March 2023 0 Comments

The issue was solved in a dataminer release. The issue was with one call the get external parameter or get table which was returning 10x the information behind the scene. This was solved in the SLNet message that was getting returned.

Geovanny Galeano [SLC] [DevOps Advocate] Selected answer as best 27th March 2023
3
Joey Vanhalst [SLC] [DevOps Advocate]1.80K Posted 25th July 2022 0 Comments

As you are using the DMS interface from the Class Library, the data is retrieved via SLNet. I suggest to also check the load on the SLNet process at the time you are executing the script as this can have an impact on the time it will take to execute these requests.

Do you need to get all the data from these tables? If not, you could also apply additional filters, which could have a big impact on performance.

Joey Vanhalst [SLC] [DevOps Advocate] Answered question 25th July 2022
Please login to be able to comment or post an answer.

My DevOps rank

DevOps Members get more insights on their profile page.

My user earnings

0 Dojo credits

Spend your credits in our swag shop.

0 Reputation points

Boost your reputation, climb the leaderboard.

Promo banner DataMiner DevOps Professiona Program
DataMiner Integration Studio (DIS)
Empower Katas

Recent questions

Web Applications exception in Cube due to invalid certificate 0 Answers | 0 Votes
Redundancy Groups and Alarming – Duplicate Alarms 0 Answers | 0 Votes
Correlation Engine: “Test rule” doesn’t result in a hit, despite functional rule 1 Answer | 3 Votes

Question Tags

adl2099 (115) alarm (62) Alarm Console (82) alarms (100) alarm template (83) Automation (223) automation scipt (111) Automation script (167) backup (71) Cassandra (180) Connector (109) Correlation (69) Correlation rule (52) Cube (151) Dashboard (194) Dashboards (188) database (83) DataMiner Cube (57) DIS (81) DMS (71) DOM (140) driver (65) DVE (56) Elastic (83) Elasticsearch (115) elements (80) Failover (104) GQI (159) HTTP (76) IDP (74) LCA (152) low code app (166) low code apps (93) lowcodeapps (75) MySQL (53) protocol (203) QAction (83) security (88) SNMP (86) SRM (337) table (54) trending (87) upgrade (62) Visio (539) Visual Overview (345)
Privacy Policy • Terms & Conditions • Contact

© 2025 Skyline Communications. All rights reserved.

DOJO Q&A widget

Can't find what you need?

? Explore the Q&A DataMiner Docs

[ Placeholder content for popup link ] WordPress Download Manager - Best Download Management Plugin