I have a bit of a technical question one of our IT folks is asking. We have a production line with its own MSSQL database. Production folks asked me to tie into a MSSQL database from a separate operation to pull daily production data. No problem, had it up and working in no time. This “secondary” connection is only to pull production data two or three times a day. The IT fella is concerned that the connection always stays open, and Ignition is querying the DB every four seconds. I’m assuming this is solely to check connectivity, correct? At any rate, I’m trying to appease him, and wanted to find out:
- Is there any way that I can, through scripting, connect only as required, query the data, then close the connection? This would be his favorite option.
- Either turn off or increase the delay on the connectivity query, so we’re not checking every four seconds or so?
- Any documentation I can point him to that says this isn’t a problem.