Differences
This shows you the differences between two versions of the page.
| Next revision | Previous revision | ||
| en:dpi:qoe_analytics:cases:queries_from_database:problematic_subscribers [2025/10/30 13:31] – created elena.krasnobryzh | en:dpi:qoe_analytics:cases:queries_from_database:problematic_subscribers [2025/11/01 07:58] (current) – [Internet quality degradation] elena.krasnobryzh | ||
|---|---|---|---|
| Line 42: | Line 42: | ||
| Example database query:\\ | Example database query:\\ | ||
| - | {{ :en: | + | {{ : |
| The script returns a list of subscribers who visited the specified competitor sites any number of times during the last 24 hours. | The script returns a list of subscribers who visited the specified competitor sites any number of times during the last 24 hours. | ||
| Line 82: | Line 82: | ||
| Example database query:\\ | Example database query:\\ | ||
| - | {{ :en: | + | {{ : |
| Run '' | Run '' | ||
| Line 92: | Line 92: | ||
| ===== Internet quality degradation ===== | ===== Internet quality degradation ===== | ||
| - | The simplest and most well-studied DPI metric for assessing connection quality is [[https://bezopasnik.info/что-такое-время-приема-передачи-rtt/ | + | The simplest and most well-studied DPI metric for assessing connection quality is [[https://en.wikipedia.org/wiki/Round-trip_delay|RTT]]. DPI can measure RTT and separate results by direction (to and from subscriber) and by protocols or devices if necessary. A high “RTT from subscriber” value over a long period likely means that the subscriber is experiencing problems accessing online services such as gaming, video, or communication. Usually, this is due to the Wi-Fi network, but it can also indicate congestion in the operator’s network. |
| Actions: | Actions: | ||
| Line 129: | Line 129: | ||
| Example database query:\\ | Example database query:\\ | ||
| - | {{ :en: | + | {{ : |
| Script parameters: | Script parameters: | ||