fttb slow response time about framework

[luceos]

Please provide output of php flarum info as requested, but do it on discuss first:

https://discuss.flarum.org/d/32646-fttb-slow-response-time

[davwheat]

If I had to guess, it'd probably be due to the notification count attribute rather than loading of the notifications themselves

[UserZHTW]

If I had to guess, it'd probably be due to the notification count attribute rather than loading of the notifications themselves

I read all the notifications, but the response is still very slow. Only by delete all notifications, the server response will be faster

[SychO9]

I have yet to confirm, but this may be due to using property_exists before calling disussion_id, I just noticed it wouldn't detect magically added properties, so that was a bad change in 1.7

https://github.com/flarum/framework/blob/main/framework/core/src/Api/Controller/ListNotificationsController.php#L116

[SychO9]

Looking at the notifications logic, I don't see how this could happen, notifications are paginated, and loading the count is not a resource-intensive query. This could be a bad extension.

[UserZHTW]

Looking at the notifications logic, I don't see how this could happen, notifications are paginated, and loading the count is not a resource-intensive query. This could be a bad extension.

I turned off all extensions and the problem still exists
Still need to delete all notifications to speed up web page access

Flarum core: 1.8.3
PHP version: 8.1.26

+--------------------------------+----------+--------+
| Flarum Extensions              |          |        |
+--------------------------------+----------+--------+
| ID                             | Version  | Commit |
+--------------------------------+----------+--------+
| flarum-flags                   | v1.8.0   |        |
| flarum-approval                | v1.8.1   |        |
| flarum-tags                    | v1.8.0   |        |
| kater-lang-traditional-chinese | dev-main |        |
| flarum-suspend                 | v1.8.1   |        |
| flarum-subscriptions           | v1.8.0   |        |
| flarum-sticky                  | v1.8.0   |        |
| flarum-statistics              | v1.8.0   |        |
| flarum-nicknames               | v1.8.0   |        |
| flarum-mentions                | v1.8.2   |        |
| flarum-markdown                | v1.8.0   |        |
| flarum-lock                    | v1.8.0   |        |
| flarum-lang-english            | v1.8.0   |        |
| flarum-emoji                   | v1.8.0   |        |
| flarum-bbcode                  | v1.8.0   |        |
+--------------------------------+----------+--------+