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
  • Updates & Insights
  • Questions
  • Learning
    • E-learning Courses
    • Empower Replay: Limited Edition
    • Tutorials
    • 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
    • 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
    • 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
      • About the DevOps Program
      • DataMiner DevOps Support
  • Downloads
  • More
    • DataMiner Releases & Updates
    • Feature Suggestions
    • Climb the leaderboard!
    • Swag Shop
    • Contact
    • Global Feedback Survey
  • PARTNERS
    • All Partners
    • Technology Partners
    • Strategic Partner Program
    • Deal Registration
  • >> Go to dataminer.services

Is there a suggested data type for Element Table Primary Keys?

Solved1.34K views3rd May 2023driver development primary key
4
Gabriel Borges [SLC] [DevOps Advocate]646 26th April 2023 0 Comments

Hello Dojo,

We are currently retrieving a large amount of data that we are going to be saving to a table. These entries all have unique names (no longer than 20 characters long). We are estimating having at least 500k rows. Is there a benefit to assigning unique Numeric Text Primary Keys or is the name in String format just as efficient?

Jan-Klaas Kesteloot [SLC] [DevOps Advocate] Answered question 3rd May 2023

2 Answers

  • Active
  • Voted
  • Newest
  • Oldest
1
Jan-Klaas Kesteloot [SLC] [DevOps Advocate]1.13K Posted 3rd May 2023 1 Comment

As a general remark, please be aware of the performance degradation you risk to have if your table holds 500k rows. So I'd like to challenge if there's really a need to save the table or can it be made volatile instead? Can you use a logger table instead of a regular table?

Big tables can cause Cassandra compactions issue because of (too) large partition sizes. Additionally, if you save the data, element startup (and DataMiner startup) will be slow.

Gabriel Borges [SLC] [DevOps Advocate] Posted new comment 3rd May 2023
Gabriel Borges [SLC] [DevOps Advocate] commented 3rd May 2023

Thank you for this information Jan. We are making the table volatile to help Cassandra as we have had previous issues with tombstones (Cassandra running on a Windows Server) so I guess the keys won’t be saved to Cassandra, but they will be used to pull the data to the Client.

You are viewing 1 out of 2 answers, click here to view all answers.
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
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