Table with many columns a rows Best Practice

Solved119 views
3
0 Comments

Hello

I have a project to keep ma table with 30 columns and arround 5000 rows, it have to be updated arround one time per day, its best use DOM or Logger table? the idea its make querys in LCA or Custom API. if i use Looger each row can be updated?

Thanks

Juan

Juan Falcon Selected answer as best 11th November 2025

1 Answer

0
14.29K 1 Comment

Hi Juan,

I’ll include regular tables in the comparison as well. In theory you can make every storage work, but the best suitable solution depends on what you want to do with the data.

• Logger table: No monitoring or trending, typically append-only, so not meant for overwrites.
• Regular parameter table: Support alarms and trending, making them suitable for live monitoring, KPI storage, and trending, can be overwritten.
• DOM: best for structured administrative or business data, can be overwritten.

If the requirement is to use the data in LCA and user defined APIs, then DOM sounds like a logical choice.

Juan Falcon Posted new comment 11th November 2025
Juan Falcon commented

Thanks por the advice