Use piconfig to set the history flush interval

Use the piconfig utility to set the ConnectionHistoryFlushInterval parameter in the pitimeout table. The value is in seconds: the minimum is 1, maximum is 3,600 (1 hour), and default is 10.

ConnectionHistoryFlushInterval controls how often updates are committed. Updates can include license table updates, connection history data, and so on.

A lower value for this parameter means less data is stored in memory, but more frequent high-CPU usage occurs (when data is written to the database). This would be ideal for a system with plenty of resources and to which there are a high number of connections.

A higher value for this parameter means less frequent high-CPU usage, but data would be committed less often.

The following example sets ConnectionHistoryFlushInterval to 15 seconds.

C:\Program Files\PI\adm>piconfig.exe
* (Ls - ) PIconfig> @mode edit
* (Ed - ) PIconfig> @tabl pitimeout
* (Ed - PITIMEOUT) PIconfig> @istr name,value
* (Ed - PITIMEOUT) PIconfig> ConnectionHistoryFlushInterval, 15
*> ConnectionHistoryFlushInterval, 15
* (Ed - PITIMEOUT) PIconfig> @mode list
* (Ls - PITIMEOUT) PIconfig> @ostr name,value
* (Ls - PITIMEOUT) PIconfig> @istr name
* (Ls - PITIMEOUT) PIconfig> ConnectionHistoryFlushInterval
*> ConnectionHistoryFlushInterval
ConnectionHistoryFlushInterval,15
* (Ls - PITIMEOUT) PIconfig> @ends
* (Ls - PITIMEOUT) PIconfig> @quit

PIconfig 2 Data lines
8 Command line
0 Records in error...
1 Records Edited
1 Records Listed

For more information about using the piconfig utility, see Configure Data Archive tables using piconfig .