https://bugzilla.wikimedia.org/show_bug.cgi?id=57043
--- Comment #3 from [email protected] --- The query actually has some problem for users with large volume of notifications. Imagine a user has 500k notifications and the user has not received any thank notification, the query has to look through all 500k records to find the result. Of course, in reality, most of the users wouldn't have that big number of notifications, I guess this is okay. In theory, this query still has some potential risk. Mobile shouldn't fire a query directly to Echo tables, I agree that the functionality should be abstracted in Echo or Thanks. With that, we could also add some cache support, eg, storing the latest thanks in memcache. -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. _______________________________________________ Wikibugs-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
