Historization data limit

Ignition
1

Hi everyone,

Is there any limit in data points that could be stored in a history partition in order to assure a proper functionality? Or maybe a recomended maximum size?

I actually have month partitions with more than 300M points each and it's working well. And another project with month partitions too, wich could scale up to 1 billion points of data.

Thanks in advance for any experience or recomendation.

MC

2

Totally depends on the database. Those aren't exotic numbers for the popular production-grade databases[1] most people use. As long as you are using decent DB hardware, and occasionally look for pathologically long queries, you are likely to be fine. (Look for long queries so you can analyze them and tweak your indexing/stats management on the DB.)

  1. I count PostgreSQL, MariaDB, and Oracle in that group. And MS SQL Server if I poke my eyes out. ↩ī¸Ž

1 Like