The notifications AJAX code and database table were updated to increase performance. As in yesterday's updates, there is still a lot of unoptimized code killing performance. However, notifications are requested through frequent queries on every page, so it made for some good optimization. For a sense of scale, AJAX requests about notifications were about 14.2% of the requests for the site in the past hour.
Technical details:
- In the notifications table, changed column of type int that only ever used values of 0 and 1 to bit type. Updated queries accordingly.
- Created a more effective concatenated index for notifications queries.
Post has been edited 2 time(s), last time on May 10 2017, 2:30 am by Mini Moose 2707.
