Versions Compared

Old Version 3

changes.mady.by.user Evgeniya Kononova

Saved on

compared with

New Version Current

changes.mady.by.user Alena Kniazeva

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

All events that Auto PSIM receives from the LPR channel, are stored are stored in the SQL database. Eventually, the SQL database reaches a large size, which leads to the Server CPU increase in server load increase. To limit the size of the SQL database size, you can specify the retention period of archive size in the database records.

Info
titleNote

When configuring In this case, when you configure the LPR channel , you specified and specify the retention period of the database records that is shorter than it was before, the database will gradually clean cleans itself.

If the Debug 4 debugging mode is enabled, then when the SQL database queue reaches 1000 or more queries, the events will be are generated in the Event Viewer every viewer every 10 seconds, indicating the current queue until the queue is less than 1000 (for details, see Enable, disable, change the mode of the Debug window).

To configure the archive size in the database records retention period, do the following:

  1. Go to the settings panel of the LPR channel object, corresponding to the activated module (see Activating the software module used for identifying license plates).
  2. Go to the Saving settings tab.
  3. In the Archive size, days field, specify the number of days that records are stored in the database. The default value is 30. The value range is 0-–5000.
  4. Click the Apply button.

The database records retention period is configuredConfiguration of archive size in the database is complete.