Database communication performance

Archived Topics
1

Imagine we have 3k+ tags that we want to store in the database periodically. We use historical logging and transaction groups for that. So that the amount of queries is quite high. What should we consider when creating high database load? Where COULD BE the bottleneck with such setup? It is Ignition, JDBC driver, or the database itself? Should we increase buffers for faultless work?

These 3k+ is given for an example.

Opinions please :slight_smile:

2

Need a bit of information. What database are you using. How fast do you store data? How often is data changing? What do you consider to be a high database load? Are you seeing poor performance, or is this a precaution? What is your current hardware? What is the rest of the system doing? Are you only storing data? Are you running simple or complex queries against this data?