Log Analyzer - Cache Users for Trace Flag Entities

[Justin Julicher]

When setting trace flags for organisations with a large amount of users it would be good if this could be cached.

‌

‌

[Scott Wells]

Yeah, this was discussed in #1417 as well. I do cache the users and classes for the duration of that dialog, but if you close it and reopen it then it has to run the query again. I don't cache it for longer than that because it gets into the whole issue of a cache expiration. I suppose I could keep track of when the most recent user was last modified and just run a query like:

SELECT LastModifiedDate
FROM User
ORDER BY LastModifiedDate DESC
LIMIT 1

to determine whether to evict/repopulate the cache. I'll think about it a bit...

[Justin Julicher]

That would be great - just updating the users but the last modified would make a great difference.

[Scott Wells]

I think this should have been resolved by changes that were made in the semi-recent (last 1-1.5 years) past. Let me know if you're still seeing performance issues.