All the events Auto Intellect receives from the LPR channel, are stored in the SQL database. Eventually it reaches large size, which leads to the Server CPU load increase. To limit the SQL database size you can specify the database records retention period.
In case the database records retention period is specified shorter than before while configuring the LPR channel, the database will gradually clean itself. If the Debug 4 debugging mode is enabled, then when the SQL database queue reaches 1000 or more queries, the events will be generated in the Event Log every 10 seconds indicating the current queue until the queue is less than 1000 (for details, see Enabling the Debug window). |
To configure the database records retention period, do the following:
The database records retention period is configured.