Come together with the global Drupal community in Rotterdam, 28 Sept – 1 Oct 2026. Sessions, contribution, connection, and Early Bird savings until 8 June.Have you guys thought about user / role caching at all? I'm back to doing some query tuning on my site and noticed one query in particular that executes a lot and seems to be a waste:
6.62 user_load SELECT r.rid, r.name FROM role r INNER JOIN users_roles ur ON ur.rid = r.rid WHERE ur.uid = 2
It's a simple inner join of users to roles so you'd think it would execute faster, but for some reason it doesn't. Is this worthy of caching?
