I am currently developing a driver that will need to have a significant number of columns. I was wondering if there is a maximum amount of columns a single table can have.
Marieke Goethals [SLC] [DevOps Catalyst] Selected answer as best 7th July 2023
Rebecca,
While the number of columns is very flexible, there are limitations linked to the maximum number of parameters (see Limits) that a single DMA can host. In the case of tables, each cell counts for a single parameter towards the limit.
Depending on the purpose of your table, you might want to explore logger tables (Logger tables | DataMiner Docs), which may help reduce the load on the system.
Marieke Goethals [SLC] [DevOps Catalyst] Selected answer as best 7th July 2023
I would also note that there is a limit on the number of cells a client can display without putting too much load on the client.
If your table, next to a lot of columns also has a lot of rows, that can cause slow behavior.
I therefore would also advise using ‘partial’ on the table in case you have a large amount of cells.
That way you limit the amount of rows the client shows. This splits up the table in pages.
https://docs.dataminer.services/develop/schemadoc/Protocol/Protocol.Params.Param.ArrayOptions-partial.html