User / role caching?
ilmaestro - January 25, 2008 - 18:33
| Project: | Advanced cache |
| Version: | 5.x-1.5 |
| Component: | Code |
| Category: | feature request |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | active |
Description
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?