The tag reading on the gateway network takes too long

The references.idb file located at \Ignition\data\diagnostics\tags\default\ is experiencing excessive write I/O. Compared to other system tag counts on the gateway, this is affecting the gateway network's tag reading, causing delays of tens of seconds before values can be read. I would like to know which operati


ons or functions might be causing writes to this file.

That is the tag references tracker. If your gateway disk storage is too wimpy to use it with your application, disable it (per tag provider).

I would be surprised if this is actually true, also. You should contact support, but the TRT was pretty carefully engineered to be independent of main tag execution re: threading. So unless the whole system is struggling to keep up, it's unlikely TRT is actually the root cause here; more likely a symptom of some other problem.

Is IA testing gateway hardware that doesn't have a solid-state disk? (Spinning rust crushes DBs that try hard to not corrupt themselves. SQLite is a terrible choice for the TRT.)

I would assume hope so, some pretty careful performance testing was done, but I don't actually know for sure.

I also would've thought we'd use SQLite's WAL mode for TRT, though a quick glance doesn't show that we are :person_shrugging:. I wasn't involved in the backend, just know from osmosis some of the concerns around implementation.

Heh, I would assume not :person_shrugging:

and don't even think about using anything but an SSD for Ignition 8.3...

2 Likes