Bug ID 685741: DoS Overview is very slow to load data, to the point of timeout

Last Modified: Nov 26, 2018

Bug Tracker

Affected Product:  See more info
BIG-IP AFM, ASM, AVR(all modules)

Known Affected Versions:
12.1.0, 12.1.0 HF1, 12.1.0 HF2, 12.1.1, 12.1.1 HF1, 12.1.1 HF2, 12.1.2, 12.1.2 HF1, 12.1.2 HF2, 12.1.3, 12.1.3.1, 12.1.3.2, 12.1.3.3, 12.1.3.4, 12.1.3.5, 12.1.3.6

Fixed In:
12.1.3.7

Opened: Sep 27, 2017
Severity: 3-Major

Symptoms

When logs contains more than 1 million records, loading of attacks data is extremely slow and requires many SQL queries.

Impact

DoS Overview page is unusable

Conditions

N/A

Workaround

N/A

Fix Information

The fix revolved around combining all the required data into a couple of queries instead of sending distinct queries for every attack.

Behavior Change