Patch (to be ported)
Project:
Notifications
Version:
6.x-2.x-dev
Component:
Notifications
Priority:
Normal
Category:
Task
Assigned:
Unassigned
Reporter:
Created:
16 Nov 2012 at 10:56 UTC
Updated:
16 Nov 2012 at 10:56 UTC
One of the sites I was recently profiling showed up to 300ms to retrieve data from the notifications table. Adding an index over the uid and type columns dropped this to an average of 0.2ms.
It's an easy performance win, here's a patch to the install file allowing the index to be added.
| Comment | File | Size | Author |
|---|---|---|---|
| notifications-uidtypecolumnindex.patch | 579 bytes | johan.gant |