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

Which database tables are used when defining a logger table?

Solved936 views13th February 2023arrayoptions logger table SLProtocol
7
Brecht Deconinck [SLC] [DevOps Member]1.20K 3rd February 2023 0 Comments

When defining a logger table, according to the documentation, only a limited number of rows is loaded in the SLProtocol process.

https://docs.dataminer.services/develop/devguide/Connector/AdvancedLoggerTables.html

https://docs.dataminer.services/develop/schemadoc/Protocol/Protocol.Params.Param.ArrayOptions-options.html#database

Does this mean that only that limited amount of rows is also stored in the elementdata table?
Or is there never data stored in the elementdata table when using a logger table?
In case there’s partial data stored in the elementdata table when using a logger table, should we combine this with the volatile option?

When using a logger table, in what database table can we find the table’s data?

Brecht Deconinck [SLC] [DevOps Member] Selected answer as best 13th February 2023

1 Answer

  • Active
  • Voted
  • Newest
  • Oldest
5
Michiel Saelen [SLC] [DevOps Enabler]5.63K Posted 6th February 2023 0 Comments

Hi Brecht,

Logger tables are stored in a separate table in the DB created specifically for that element. So it should not be stored in the elementdata table in DB as it is already in a custom table in DB. When opening the element in Cube you will want to see the content of that table asap, this is why a part of the data is stored in the SLProtocol process, so that part can already be returned to the client while other parts can be loaded later through lazy loading if needed. So only a part to avoid blowing up memory in case of large logger tables. That part is in memory to still have reasonable responsiveness when retrieving the table through lazy loading.

The logger table can be stored in Cassandra and/or Elastic. Depending on your use case you might want to choose one over the other. I would recommend using Elastic if there might/can be many elements on a DMS using that logger table. As Cassandra can’t cope well with many DB tables (>200).

Brecht Deconinck [SLC] [DevOps Member] Selected answer as best 13th February 2023
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