[rt-devel] More query debugging
Jeroen Ruigrok/asmodai
asmodai at wxs.nl
Wed Apr 16 11:24:13 EDT 2003
When giving a user rights, or revoking them in the global user rights
section of rt the queries will show this all of a sudden:
2003-04-16 15:18:24 [70729] LOG: query: SELECT * FROM CachedGroupMembers WHERE Disabled = 0 AND GroupId = '47' AND MemberId = '24'
2003-04-16 15:18:24 [70729] LOG: duration: 0.003285 sec
2003-04-16 15:18:24 [70729] LOG: query: SELECT * FROM CachedGroupMembers WHERE Disabled = 0 AND GroupId = '47' AND MemberId = '24'
2003-04-16 15:18:24 [70729] LOG: duration: 0.003357 sec
2003-04-16 15:18:24 [70729] LOG: query: SELECT * FROM CachedGroupMembers WHERE Disabled = 0 AND GroupId = '47' AND MemberId = '24'
2003-04-16 15:18:24 [70729] LOG: duration: 0.003236 sec
2003-04-16 15:18:24 [70729] LOG: query: SELECT * FROM CachedGroupMembers WHERE Disabled = 0 AND GroupId = '47' AND MemberId = '24'
2003-04-16 15:18:24 [70729] LOG: duration: 0.003256 sec
2003-04-16 15:18:24 [70729] LOG: query: SELECT * FROM CachedGroupMembers WHERE Disabled = 0 AND GroupId = '47' AND MemberId = '24'
2003-04-16 15:18:24 [70729] LOG: duration: 0.003254 sec
2003-04-16 15:18:24 [70729] LOG: query: SELECT * FROM CachedGroupMembers WHERE Disabled = 0 AND GroupId = '47' AND MemberId = '24'
2003-04-16 15:18:24 [70729] LOG: duration: 0.003250 sec
2003-04-16 15:18:24 [70729] LOG: query: SELECT * FROM CachedGroupMembers WHERE Disabled = 0 AND GroupId = '47' AND MemberId = '24'
2003-04-16 15:18:24 [70729] LOG: duration: 0.003277 sec
2003-04-16 15:18:24 [70729] LOG: query: SELECT * FROM CachedGroupMembers WHERE Disabled = 0 AND GroupId = '47' AND MemberId = '24'
2003-04-16 15:18:24 [70729] LOG: duration: 0.003254 sec
2003-04-16 15:18:24 [70729] LOG: query: SELECT * FROM CachedGroupMembers WHERE Disabled = 0 AND GroupId = '47' AND MemberId = '24'
2003-04-16 15:18:24 [70729] LOG: duration: 0.003275 sec
2003-04-16 15:18:24 [70729] LOG: query: SELECT * FROM CachedGroupMembers WHERE Disabled = 0 AND GroupId = '47' AND MemberId = '24'
2003-04-16 15:18:24 [70729] LOG: duration: 0.003506 sec
2003-04-16 15:18:24 [70729] LOG: query: SELECT * FROM CachedGroupMembers WHERE Disabled = 0 AND GroupId = '47' AND MemberId = '24'
2003-04-16 15:18:24 [70729] LOG: duration: 0.003283 sec
2003-04-16 15:18:24 [70729] LOG: query: SELECT * FROM CachedGroupMembers WHERE Disabled = 0 AND GroupId = '47' AND MemberId = '24'
2003-04-16 15:18:24 [70729] LOG: duration: 0.003278 sec
2003-04-16 15:18:24 [70729] LOG: query: SELECT * FROM CachedGroupMembers WHERE Disabled = 0 AND GroupId = '47' AND MemberId = '24'
2003-04-16 15:18:24 [70729] LOG: duration: 0.003275 sec
2003-04-16 15:18:24 [70729] LOG: query: SELECT * FROM CachedGroupMembers WHERE Disabled = 0 AND GroupId = '47' AND MemberId = '24'
2003-04-16 15:18:24 [70729] LOG: duration: 0.003411 sec
2003-04-16 15:18:24 [70729] LOG: query: SELECT * FROM CachedGroupMembers WHERE Disabled = 0 AND GroupId = '47' AND MemberId = '24'
2003-04-16 15:18:24 [70729] LOG: duration: 0.003252 sec
2003-04-16 15:18:24 [70729] LOG: query: SELECT * FROM CachedGroupMembers WHERE Disabled = 0 AND GroupId = '47' AND MemberId = '24'
2003-04-16 15:18:24 [70729] LOG: duration: 0.003267 sec
2003-04-16 15:18:24 [70729] LOG: query: SELECT * FROM CachedGroupMembers WHERE Disabled = 0 AND GroupId = '47' AND MemberId = '24'
2003-04-16 15:18:24 [70729] LOG: duration: 0.003280 sec
2003-04-16 15:18:24 [70729] LOG: query: SELECT * FROM CachedGroupMembers WHERE Disabled = 0 AND GroupId = '47' AND MemberId = '24'
2003-04-16 15:18:24 [70729] LOG: duration: 0.003618 sec
2003-04-16 15:18:24 [70729] LOG: query: SELECT * FROM CachedGroupMembers WHERE Disabled = 0 AND GroupId = '47' AND MemberId = '24'
2003-04-16 15:18:24 [70729] LOG: duration: 0.003269 sec
2003-04-16 15:18:24 [70729] LOG: query: SELECT * FROM CachedGroupMembers WHERE Disabled = 0 AND GroupId = '47' AND MemberId = '24'
2003-04-16 15:18:24 [70729] LOG: duration: 0.003288 sec
2003-04-16 15:18:24 [70729] LOG: query: SELECT * FROM CachedGroupMembers WHERE Disabled = 0 AND GroupId = '47' AND MemberId = '24'
2003-04-16 15:18:24 [70729] LOG: duration: 0.003262 sec
2003-04-16 15:18:24 [70729] LOG: query: SELECT * FROM CachedGroupMembers WHERE Disabled = 0 AND GroupId = '47' AND MemberId = '24'
2003-04-16 15:18:24 [70729] LOG: duration: 0.004167 sec
2003-04-16 15:18:24 [70729] LOG: query: SELECT * FROM CachedGroupMembers WHERE Disabled = 0 AND GroupId = '47' AND MemberId = '24'
2003-04-16 15:18:24 [70729] LOG: duration: 0.003274 sec
2003-04-16 15:18:24 [70729] LOG: query: SELECT * FROM CachedGroupMembers WHERE Disabled = 0 AND GroupId = '47' AND MemberId = '24'
2003-04-16 15:18:24 [70729] LOG: duration: 0.003281 sec
I can understand using it once of twice, but so often the same query
right after another seems a bit wasteful. Of course, the times are
very, very small and little, but avoiding repeating this 23 times would
be smart as well. :)
Especially if a few run next to eachother.
--
Jeroen Ruigrok van der Werven <asmodai(at)wxs.nl> / asmodai / a capoeirista
PGP fingerprint: 2D92 980E 45FE 2C28 9DB7 9D88 97E6 839B 2EAC 625B
http://www.tendra.org/ | http://www.in-nomine.org/~asmodai/diary/
Only the wisest and the stupidest of men never change...
More information about the Rt-devel
mailing list