[Rt-devel] RT3 Speed - Tickets display
Matthew Watson
matthew.watson at staff.netspace.net.au
Thu Nov 25 01:47:52 EST 2004
> -----Original Message-----
> From: Jesse Vincent [mailto:jesse at bestpractical.com]
> Sent: Thursday, November 25, 2004 2:28 PM
> To: Matthew Watson
> Cc: Jesse Vincent; rt-devel at lists.bestpractical.com
> Subject: Re: [Rt-devel] RT3 Speed - Tickets display
>
> > > >
> > > > In the ever continuing effort to get RT3 up to acceptable
speed,
> > I'm
> > > > currently trying to speed up Ticket display page, particularly
when
> > > > dealing with
> > > >
> > > > Large tickets.
> > >
> > > Can you verify that you're testing against the latest release of
RT
> > 3.2,
> >
> > Using version 3.2.2
> >
> > > DBIx::SearchBuilder (Ideally, the 1.13 test versions)
> >
> > Using 1.12 , more than happy to try 1.13 but I can't find it (or
even
> > any thing close to current) in
> > http://download.bestpractical.com/pub/rt/devel/
> >
>
> search.cpan.org
>
Cool I'll have a look
> > > Cache::SimpleTimedExpirey?
> >
> > 0.22
> >
> > > Ideally, you could also run your tests against RT 3.3.11.
> >
> > Unfortunately I don't really have time to try against 3.3.11 at the
> > moment, is the database schema much different? I'm 80% through
importing
> > over a million tickets into 3.2, so if the database schema is
different
> > then there is no chance :) Is there a release date for 3.3 stable
(or
> > will it be 3.4?)
>
>
>
> Importing into 3.2? The changes from 3.0 to 3.2 were an in-database
SQL
> transform. Just like 3.2 to 3.3. There's no set date for 3.4.0 That's
> entirely dependent on public response to the betas. But we've spent a
> fair amount of time on performance for this next release. We're seeing
> pages render in .5s that used to take 4-5s on the same hardware and
> database.
Cool, if there is increases like that in the works, then I'm not majorly
concerned about this. Only a very very small % of our tickets have more
than 10-20 Transactions, so its not a huge issue.
> Anyway, your profiling numbers looked..high. Can you get us database
> query logs and performance numbers from your database? For your 100
txn
> ticket, how much text is there? how many attachments?
I hope this is what you are after?
select count(*) from transactions where ticket=879444
COUNT(*)
----------
103
1 row selected
select count(*)
from transactions t, attachments a
where t.id = a.transactionid
and ticket=879444
COUNT(*)
----------
250
1 row selected
select sum(length(content))
from transactions t, attachments a
where t.id = a.transactionid
and ticket=879444
SUM(LENGTH(CONTENT))
--------------------
34806
1 row selected
Attached are the queries that actually make it to the database and the
time they took to execute.
> I'm starting to feel like the ticket history just needs to be paged.
> Even blatting out pure html from a static file, 100 transactions is
> nothing to sniff at.
Cool, like I said, this is a very small % of our tickets that get this
big, so its not a huge deal. Most tickets are now loading in under 5
seconds (with small tickets under 2 seconds).
Matt.
> >
> > Regards,
> > Matt.
> >
> > > >
> >
> > This email and any files transmitted with it are confidential and
> intended solely for the
> > use of the individual or entity to whom they are addressed. Please
> notify the sender
> > immediately by email if you have received this email by mistake and
> delete this email
> > from your system. Please note that any views or opinions presented
in
> this email are solely
> > those of the author and do not necessarily represent those of the
> organisation.
> > Finally, the recipient should check this email and any attachments
for
> the presence of
> > viruses. The organisation accepts no liability for any damage caused
by
> any virus
> > transmitted by this email.
> >
>
> --
-------------- next part --------------
0.001593,SELECT * FROM Users WHERE lower(Name) = ?
0.002032,SELECT * FROM Users WHERE id = ?
0.001913,SELECT * FROM Principals WHERE lower(PrincipalType) = ? AND ObjectId = ?
0.001892,SELECT * FROM Groups WHERE lower(Domain) = ? AND lower(Type) = ?
0.001923,SELECT * FROM GroupMembers WHERE GroupId = ? AND MemberId = ?
0.00227,SELECT * FROM Tickets WHERE id = ?
0.001851,SELECT * FROM Queues WHERE id = ?
0.009428,SELECT * FROM ( SELECT limitquery.*,rownum limitrownum FROM ( SELECT ACL.id from ACL, Groups, Principals, CachedGroupMembers WHERE (ACL.RightName = 'SuperUser' OR ACL.RightName = 'ShowTicket') AND Principals.Disabled = 0 AND CachedGroupMembers.Disabled = 0 AND Principals.id = Groups.id AND Principals.id = CachedGroupMembers.GroupId AND CachedGroupMembers.MemberId = '174' AND ( ACL.ObjectType = 'RT::System' OR (ACL.ObjectType = 'RT::Ticket' AND ACL.ObjectId = '879444') OR (ACL.ObjectType = 'RT::Queue' AND ACL.ObjectId = '7')) AND ( ( ACL.PrincipalId = Principals.id AND ACL.PrincipalType = 'Group' AND (Groups.Domain = 'SystemInternal' OR Groups.Domain = 'UserDefined' OR Groups.Domain = 'ACLEquivalence' OR Groups.Domain = 'Personal')) ) ) limitquery WHERE rownum <= 1 ) WHERE limitrownum >= 1
0.008407,SELECT * FROM ( SELECT limitquery.*,rownum limitrownum FROM ( SELECT ACL.id from ACL, Groups, Principals, CachedGroupMembers WHERE (ACL.RightName = 'SuperUser' OR ACL.RightName = 'ShowTicketComments') AND Principals.Disabled = 0 AND CachedGroupMembers.Disabled = 0 AND Principals.id = Groups.id AND Principals.id = CachedGroupMembers.GroupId AND CachedGroupMembers.MemberId = '174' AND ( ACL.ObjectType = 'RT::System' OR (ACL.ObjectType = 'RT::Ticket' AND ACL.ObjectId = '879444') OR (ACL.ObjectType = 'RT::Queue' AND ACL.ObjectId = '7')) AND ( ( ACL.PrincipalId = Principals.id AND ACL.PrincipalType = 'Group' AND (Groups.Domain = 'SystemInternal' OR Groups.Domain = 'UserDefined' OR Groups.Domain = 'ACLEquivalence' OR Groups.Domain = 'Personal')) ) ) limitquery WHERE rownum <= 1 ) WHERE limitrownum >= 1
0.008402,SELECT * FROM ( SELECT limitquery.*,rownum limitrownum FROM ( SELECT ACL.id from ACL, Groups, Principals, CachedGroupMembers WHERE (ACL.RightName = 'SuperUser' OR ACL.RightName = 'ModifyTicket') AND Principals.Disabled = 0 AND CachedGroupMembers.Disabled = 0 AND Principals.id = Groups.id AND Principals.id = CachedGroupMembers.GroupId AND CachedGroupMembers.MemberId = '174' AND ( ACL.ObjectType = 'RT::System' OR (ACL.ObjectType = 'RT::Ticket' AND ACL.ObjectId = '879444') OR (ACL.ObjectType = 'RT::Queue' AND ACL.ObjectId = '7')) AND ( ( ACL.PrincipalId = Principals.id AND ACL.PrincipalType = 'Group' AND (Groups.Domain = 'SystemInternal' OR Groups.Domain = 'UserDefined' OR Groups.Domain = 'ACLEquivalence' OR Groups.Domain = 'Personal')) ) ) limitquery WHERE rownum <= 1 ) WHERE limitrownum >= 1
0.007929,SELECT * FROM ( SELECT limitquery.*,rownum limitrownum FROM ( SELECT ACL.id from ACL, Groups, Principals, CachedGroupMembers WHERE (ACL.RightName = 'SuperUser' OR ACL.RightName = 'OwnTicket') AND Principals.Disabled = 0 AND CachedGroupMembers.Disabled = 0 AND Principals.id = Groups.id AND Principals.id = CachedGroupMembers.GroupId AND CachedGroupMembers.MemberId = '174' AND ( ACL.ObjectType = 'RT::System' OR (ACL.ObjectType = 'RT::Ticket' AND ACL.ObjectId = '879444') OR (ACL.ObjectType = 'RT::Queue' AND ACL.ObjectId = '7')) AND ( ( ACL.PrincipalId = Principals.id AND ACL.PrincipalType = 'Group' AND (Groups.Domain = 'SystemInternal' OR Groups.Domain = 'UserDefined' OR Groups.Domain = 'ACLEquivalence' OR Groups.Domain = 'Personal')) ) ) limitquery WHERE rownum <= 1 ) WHERE limitrownum >= 1
0.002005,SELECT * FROM Users WHERE id = ?
0.006905,SELECT * FROM ( SELECT limitquery.*,rownum limitrownum FROM ( SELECT ACL.id from ACL, Groups, Principals, CachedGroupMembers WHERE (ACL.RightName = 'SuperUser' OR ACL.RightName = 'SuperUser') AND Principals.Disabled = 0 AND CachedGroupMembers.Disabled = 0 AND Principals.id = Groups.id AND Principals.id = CachedGroupMembers.GroupId AND CachedGroupMembers.MemberId = '174' AND ( ACL.ObjectType = 'RT::System' OR (ACL.ObjectType = 'RT::System' AND ACL.ObjectId = '1')) AND ( ( ACL.PrincipalId = Principals.id AND ACL.PrincipalType = 'Group' AND (Groups.Domain = 'SystemInternal' OR Groups.Domain = 'UserDefined' OR Groups.Domain = 'ACLEquivalence' OR Groups.Domain = 'Personal')) ) ) limitquery WHERE rownum <= 1 ) WHERE limitrownum >= 1
0.003908,SELECT * FROM ( SELECT limitquery.*,rownum limitrownum FROM ( SELECT ACL.id from ACL, Groups, Principals, CachedGroupMembers WHERE (ACL.RightName = 'SuperUser' OR ACL.RightName = 'SeeQueue') AND Principals.Disabled = 0 AND CachedGroupMembers.Disabled = 0 AND Principals.id = Groups.id AND Principals.id = CachedGroupMembers.GroupId AND CachedGroupMembers.MemberId = '174' AND ( ACL.ObjectType = 'RT::System' OR (ACL.ObjectType = 'RT::Queue' AND ACL.ObjectId = '7')) AND ( ( ACL.PrincipalId = Principals.id AND ACL.PrincipalType = 'Group' AND (Groups.Domain = 'SystemInternal' OR Groups.Domain = 'UserDefined' OR Groups.Domain = 'ACLEquivalence' OR Groups.Domain = 'Personal')) ) ) limitquery WHERE rownum <= 1 ) WHERE limitrownum >= 1
0.001836,SELECT main.* FROM CustomFields main WHERE ((main.Disabled = '0')) AND ((main.Queue = '7')OR(main.Queue = '0')) ORDER BY main.SortOrder ASC
0.001876,SELECT * FROM Groups WHERE lower(Domain) = ? AND Instance = ? AND lower(Type) = ?
0.002161,SELECT main.* FROM ( SELECT DISTINCT main.id FROM Users main , Principals Principals_1, CachedGroupMembers CachedGroupMembers_2 WHERE ((CachedGroupMembers_2.GroupId = '3281114')) AND ((CachedGroupMembers_2.MemberId = Principals_1.id)) AND ((Principals_1.Disabled = '0')) AND ((main.id = Principals_1.id)) ) distinctquery, Users main WHERE (main.id = distinctquery.id) ORDER BY main.Name ASC
0.002896,SELECT main.* FROM ( SELECT DISTINCT main.id FROM GroupMembers main , Principals Principals_1 WHERE ((Principals_1.PrincipalType = 'Group')) AND ((main.GroupId = 3281114)) AND ((main.MemberId = Principals_1.id)) ) distinctquery, GroupMembers main WHERE (main.id = distinctquery.id)
0.001878,SELECT * FROM Groups WHERE lower(Domain) = ? AND Instance = ? AND lower(Type) = ?
0.002488,SELECT main.* FROM ( SELECT DISTINCT main.id FROM Users main , Principals Principals_1, CachedGroupMembers CachedGroupMembers_2 WHERE ((CachedGroupMembers_2.GroupId = '3281116')) AND ((CachedGroupMembers_2.MemberId = Principals_1.id)) AND ((Principals_1.Disabled = '0')) AND ((main.id = Principals_1.id)) ) distinctquery, Users main WHERE (main.id = distinctquery.id) ORDER BY main.Name ASC
0.001908,SELECT main.* FROM ( SELECT DISTINCT main.id FROM GroupMembers main , Principals Principals_1 WHERE ((Principals_1.PrincipalType = 'Group')) AND ((main.GroupId = 3281116)) AND ((main.MemberId = Principals_1.id)) ) distinctquery, GroupMembers main WHERE (main.id = distinctquery.id)
0.00189,SELECT * FROM Groups WHERE lower(Domain) = ? AND Instance = ? AND lower(Type) = ?
0.001651,SELECT main.* FROM ( SELECT DISTINCT main.id FROM Users main , Principals Principals_1, CachedGroupMembers CachedGroupMembers_2 WHERE ((CachedGroupMembers_2.GroupId = '3281117')) AND ((CachedGroupMembers_2.MemberId = Principals_1.id)) AND ((Principals_1.Disabled = '0')) AND ((main.id = Principals_1.id)) ) distinctquery, Users main WHERE (main.id = distinctquery.id) ORDER BY main.Name ASC
0.00142,SELECT main.* FROM ( SELECT DISTINCT main.id FROM GroupMembers main , Principals Principals_1 WHERE ((Principals_1.PrincipalType = 'Group')) AND ((main.GroupId = 3281117)) AND ((main.MemberId = Principals_1.id)) ) distinctquery, GroupMembers main WHERE (main.id = distinctquery.id)
0.001768,SELECT main.* FROM Tickets main WHERE ((main.Status != 'deleted')) AND ((main.Type = 'ticket')) AND ( ( (main.EffectiveId = '879444') ) )
0.009419,SELECT * FROM ( SELECT limitquery.*,rownum limitrownum FROM ( SELECT ACL.id from ACL, Groups, Principals, CachedGroupMembers WHERE (ACL.RightName = 'SuperUser' OR ACL.RightName = 'ShowTicket') AND Principals.Disabled = 0 AND CachedGroupMembers.Disabled = 0 AND Principals.id = Groups.id AND Principals.id = CachedGroupMembers.GroupId AND CachedGroupMembers.MemberId = '174' AND ( ACL.ObjectType = 'RT::System' OR (ACL.ObjectType = 'RT::Queue' AND ACL.ObjectId = '7')) AND ( ( ACL.PrincipalId = Principals.id AND ACL.PrincipalType = 'Group' AND (Groups.Domain = 'SystemInternal' OR Groups.Domain = 'UserDefined' OR Groups.Domain = 'ACLEquivalence' OR Groups.Domain = 'Personal')) ) ) limitquery WHERE rownum <= 1 ) WHERE limitrownum >= 1
0.001948,SELECT main.* FROM Links main WHERE ((main.Base = 'fsck.com-rt://netspace.net.au/ticket/879444')OR(main.Base = 'fsck.com-rt://netspace.net.au/ticket/879444')) AND ((main.Type = 'DependsOn')) ORDER BY main.Target ASC
0.001953,SELECT main.* FROM Tickets main WHERE ((main.Status != 'deleted')) AND ((main.Type = 'ticket')) AND ( ( (main.EffectiveId = '879444') ) )
0.001324,SELECT main.* FROM Links main WHERE ((main.Target = 'fsck.com-rt://netspace.net.au/ticket/879444')OR(main.Target = 'fsck.com-rt://netspace.net.au/ticket/879444')) AND ((main.Type = 'DependsOn')) ORDER BY main.Base ASC
0.001777,SELECT main.* FROM Tickets main WHERE ((main.Status != 'deleted')) AND ((main.Type = 'ticket')) AND ( ( (main.EffectiveId = '879444') ) )
0.001358,SELECT main.* FROM Links main WHERE ((main.Base = 'fsck.com-rt://netspace.net.au/ticket/879444')OR(main.Base = 'fsck.com-rt://netspace.net.au/ticket/879444')) AND ((main.Type = 'MemberOf')) ORDER BY main.Target ASC
0.002278,SELECT main.* FROM Tickets main WHERE ((main.Status != 'deleted')) AND ((main.Type = 'ticket')) AND ( ( (main.EffectiveId = '879444') ) )
0.001432,SELECT count(main.id) FROM Links main WHERE ((main.Target = 'fsck.com-rt://netspace.net.au/ticket/879444')OR(main.Target = 'fsck.com-rt://netspace.net.au/ticket/879444')) AND ((main.Type = 'MemberOf'))
0.00178,SELECT main.* FROM Tickets main WHERE ((main.Status != 'deleted')) AND ((main.Type = 'ticket')) AND ( ( (main.EffectiveId = '879444') ) )
0.001372,SELECT main.* FROM Links main WHERE ((main.Base = 'fsck.com-rt://netspace.net.au/ticket/879444')OR(main.Base = 'fsck.com-rt://netspace.net.au/ticket/879444')) AND ((main.Type = 'RefersTo')) ORDER BY main.Target ASC
0.001804,SELECT main.* FROM Tickets main WHERE ((main.Status != 'deleted')) AND ((main.Type = 'ticket')) AND ( ( (main.EffectiveId = '879444') ) )
0.001877,SELECT main.* FROM Links main WHERE ((main.Target = 'fsck.com-rt://netspace.net.au/ticket/879444')OR(main.Target = 'fsck.com-rt://netspace.net.au/ticket/879444')) AND ((main.Type = 'RefersTo')) ORDER BY main.Base ASC
0.001768,SELECT main.Id AS id, main.Filename AS filename, main.ContentType AS contenttype, main.Headers AS headers, main.Subject AS subject, main.Parent AS parent, main.ContentEncoding AS contentencoding, main.ContentType AS contenttype, main.TransactionId AS transactionid, main.Created AS created FROM ( SELECT DISTINCT main.id FROM Attachments main , Transactions Transactions_1, Tickets Tickets_2 WHERE ((Tickets_2.EffectiveId = '879444')) AND ((Transactions_1.Ticket = Tickets_2.id)) AND ((main.TransactionId = Transactions_1.id)) ) distinctquery, Attachments main WHERE (main.id = distinctquery.id)
0.001853,SELECT * FROM Transactions WHERE id = ?
0.001849,SELECT * FROM Transactions WHERE id = ?
0.001364,SELECT * FROM Transactions WHERE id = ?
0.001364,SELECT * FROM Transactions WHERE id = ?
0.001864,SELECT * FROM Transactions WHERE id = ?
0.00136,SELECT * FROM Transactions WHERE id = ?
0.001855,SELECT * FROM Transactions WHERE id = ?
0.001355,SELECT * FROM Transactions WHERE id = ?
0.001856,SELECT * FROM Transactions WHERE id = ?
0.001858,SELECT * FROM Transactions WHERE id = ?
0.001361,SELECT * FROM Transactions WHERE id = ?
0.001357,SELECT * FROM Transactions WHERE id = ?
0.001356,SELECT * FROM Transactions WHERE id = ?
0.001855,SELECT * FROM Transactions WHERE id = ?
0.001359,SELECT * FROM Transactions WHERE id = ?
0.00136,SELECT * FROM Transactions WHERE id = ?
0.00136,SELECT * FROM Transactions WHERE id = ?
0.001364,SELECT * FROM Transactions WHERE id = ?
0.0021,SELECT * FROM Transactions WHERE id = ?
0.001713,SELECT * FROM Transactions WHERE id = ?
0.001724,SELECT * FROM Transactions WHERE id = ?
0.00135,SELECT * FROM Transactions WHERE id = ?
0.001723,SELECT * FROM Transactions WHERE id = ?
0.001361,SELECT * FROM Transactions WHERE id = ?
0.001353,SELECT * FROM Transactions WHERE id = ?
0.00135,SELECT * FROM Transactions WHERE id = ?
0.001349,SELECT * FROM Transactions WHERE id = ?
0.001364,SELECT * FROM Transactions WHERE id = ?
0.001728,SELECT * FROM Transactions WHERE id = ?
0.001724,SELECT * FROM Transactions WHERE id = ?
0.001726,SELECT * FROM Transactions WHERE id = ?
0.001727,SELECT * FROM Transactions WHERE id = ?
0.00136,SELECT * FROM Transactions WHERE id = ?
0.002106,SELECT * FROM Transactions WHERE id = ?
0.001735,SELECT * FROM Transactions WHERE id = ?
0.001734,SELECT * FROM Transactions WHERE id = ?
0.001727,SELECT * FROM Transactions WHERE id = ?
0.001737,SELECT * FROM Transactions WHERE id = ?
0.001732,SELECT * FROM Transactions WHERE id = ?
0.001736,SELECT * FROM Transactions WHERE id = ?
0.00136,SELECT * FROM Transactions WHERE id = ?
0.00135,SELECT * FROM Transactions WHERE id = ?
0.001717,SELECT * FROM Transactions WHERE id = ?
0.001736,SELECT * FROM Transactions WHERE id = ?
0.001719,SELECT * FROM Transactions WHERE id = ?
0.001731,SELECT * FROM Transactions WHERE id = ?
0.001729,SELECT * FROM Transactions WHERE id = ?
0.001714,SELECT * FROM Transactions WHERE id = ?
0.001725,SELECT * FROM Transactions WHERE id = ?
0.001728,SELECT * FROM Transactions WHERE id = ?
0.001721,SELECT * FROM Transactions WHERE id = ?
0.001727,SELECT * FROM Transactions WHERE id = ?
0.001723,SELECT * FROM Transactions WHERE id = ?
0.001728,SELECT * FROM Transactions WHERE id = ?
0.001352,SELECT * FROM Transactions WHERE id = ?
0.001363,SELECT * FROM Transactions WHERE id = ?
0.001726,SELECT * FROM Transactions WHERE id = ?
0.001357,SELECT * FROM Transactions WHERE id = ?
0.001726,SELECT * FROM Transactions WHERE id = ?
0.001344,SELECT * FROM Transactions WHERE id = ?
0.001717,SELECT * FROM Transactions WHERE id = ?
0.001716,SELECT * FROM Transactions WHERE id = ?
0.001733,SELECT * FROM Transactions WHERE id = ?
0.00173,SELECT * FROM Transactions WHERE id = ?
0.001736,SELECT * FROM Transactions WHERE id = ?
0.00172,SELECT * FROM Transactions WHERE id = ?
0.001735,SELECT * FROM Transactions WHERE id = ?
0.001727,SELECT * FROM Transactions WHERE id = ?
0.001362,SELECT * FROM Transactions WHERE id = ?
0.001722,SELECT * FROM Transactions WHERE id = ?
0.001346,SELECT * FROM Transactions WHERE id = ?
0.001716,SELECT * FROM Transactions WHERE id = ?
0.001354,SELECT * FROM Transactions WHERE id = ?
0.001728,SELECT * FROM Transactions WHERE id = ?
0.001734,SELECT * FROM Transactions WHERE id = ?
0.001733,SELECT * FROM Transactions WHERE id = ?
0.001725,SELECT * FROM Transactions WHERE id = ?
0.001721,SELECT * FROM Transactions WHERE id = ?
0.002102,SELECT * FROM Transactions WHERE id = ?
0.001737,SELECT * FROM Transactions WHERE id = ?
0.002099,SELECT * FROM Transactions WHERE id = ?
0.001722,SELECT * FROM Transactions WHERE id = ?
0.00172,SELECT * FROM Transactions WHERE id = ?
0.00136,SELECT * FROM Transactions WHERE id = ?
0.002053,SELECT main.id AS id, main.Content AS content, main.ContentType AS contenttype, main.TransactionId AS transactionid, main.ContentEncoding AS contentencoding FROM ( SELECT DISTINCT main.id FROM Attachments main , Transactions Transactions_1, Tickets Tickets_2 WHERE ((Tickets_2.EffectiveId = '879444')) AND ((Transactions_1.Ticket = Tickets_2.id)) AND ((main.ContentType = 'text/plain')or(main.ContentType LIKE 'message/%')or(main.ContentType = 'text')) AND ((main.TransactionId = Transactions_1.id)) ) distinctquery, Attachments main WHERE (main.id = distinctquery.id)
0.010382,SELECT main.* FROM ( SELECT DISTINCT main.id FROM Transactions main , Tickets Tickets_1 WHERE ((Tickets_1.EffectiveId = '879444')) AND ((main.Ticket = Tickets_1.id)) ) distinctquery, Transactions main WHERE (main.id = distinctquery.id) ORDER BY main.Created ASC, main.id ASC
0.001751,SELECT * FROM Users WHERE id = ?
0.001872,SELECT * FROM Principals WHERE id = ?
0.001232,SELECT * FROM GroupMembers WHERE GroupId = ? AND MemberId = ?
0.002176,SELECT * FROM Principals WHERE id = ?
0.001225,SELECT * FROM GroupMembers WHERE GroupId = ? AND MemberId = ?
0.001467,SELECT content FROM Attachments WHERE id = ?
0.001182,SELECT content FROM Attachments WHERE id = ?
0.001204,SELECT * FROM GroupMembers WHERE GroupId = ? AND MemberId = ?
0.001509,SELECT content FROM Attachments WHERE id = ?
0.001519,SELECT content FROM Attachments WHERE id = ?
0.001536,SELECT * FROM GroupMembers WHERE GroupId = ? AND MemberId = ?
0.001506,SELECT content FROM Attachments WHERE id = ?
0.001186,SELECT content FROM Attachments WHERE id = ?
0.001521,SELECT * FROM GroupMembers WHERE GroupId = ? AND MemberId = ?
0.001514,SELECT content FROM Attachments WHERE id = ?
0.001184,SELECT content FROM Attachments WHERE id = ?
0.001371,SELECT * FROM GroupMembers WHERE GroupId = ? AND MemberId = ?
0.001349,SELECT content FROM Attachments WHERE id = ?
0.001352,SELECT content FROM Attachments WHERE id = ?
0.002043,SELECT * FROM Users WHERE id = ?
0.001748,SELECT * FROM Principals WHERE id = ?
0.001396,SELECT * FROM GroupMembers WHERE GroupId = ? AND MemberId = ?
0.001349,SELECT content FROM Attachments WHERE id = ?
0.001357,SELECT content FROM Attachments WHERE id = ?
0.001374,SELECT * FROM GroupMembers WHERE GroupId = ? AND MemberId = ?
0.00135,SELECT content FROM Attachments WHERE id = ?
0.001356,SELECT content FROM Attachments WHERE id = ?
0.001374,SELECT * FROM GroupMembers WHERE GroupId = ? AND MemberId = ?
0.001357,SELECT content FROM Attachments WHERE id = ?
0.001345,SELECT content FROM Attachments WHERE id = ?
0.001376,SELECT * FROM GroupMembers WHERE GroupId = ? AND MemberId = ?
0.001357,SELECT content FROM Attachments WHERE id = ?
0.001361,SELECT content FROM Attachments WHERE id = ?
0.001747,SELECT * FROM Users WHERE id = ?
0.001745,SELECT * FROM Principals WHERE id = ?
0.00139,SELECT * FROM GroupMembers WHERE GroupId = ? AND MemberId = ?
0.001356,SELECT content FROM Attachments WHERE id = ?
0.001347,SELECT content FROM Attachments WHERE id = ?
0.001455,SELECT * FROM GroupMembers WHERE GroupId = ? AND MemberId = ?
0.001111,SELECT content FROM Attachments WHERE id = ?
0.001438,SELECT content FROM Attachments WHERE id = ?
0.001722,SELECT * FROM Users WHERE id = ?
0.00178,SELECT * FROM Principals WHERE id = ?
0.001487,SELECT * FROM GroupMembers WHERE GroupId = ? AND MemberId = ?
0.001128,SELECT content FROM Attachments WHERE id = ?
0.001125,SELECT content FROM Attachments WHERE id = ?
0.001455,SELECT * FROM GroupMembers WHERE GroupId = ? AND MemberId = ?
0.001435,SELECT content FROM Attachments WHERE id = ?
0.00114,SELECT content FROM Attachments WHERE id = ?
0.001455,SELECT * FROM GroupMembers WHERE GroupId = ? AND MemberId = ?
0.001437,SELECT content FROM Attachments WHERE id = ?
0.00144,SELECT content FROM Attachments WHERE id = ?
0.001773,SELECT * FROM GroupMembers WHERE GroupId = ? AND MemberId = ?
0.001445,SELECT content FROM Attachments WHERE id = ?
0.001445,SELECT content FROM Attachments WHERE id = ?
0.001457,SELECT * FROM GroupMembers WHERE GroupId = ? AND MemberId = ?
0.00113,SELECT content FROM Attachments WHERE id = ?
0.001443,SELECT content FROM Attachments WHERE id = ?
0.00172,SELECT * FROM Users WHERE id = ?
0.001784,SELECT * FROM Principals WHERE id = ?
0.001487,SELECT * FROM GroupMembers WHERE GroupId = ? AND MemberId = ?
0.001128,SELECT content FROM Attachments WHERE id = ?
0.001442,SELECT content FROM Attachments WHERE id = ?
0.001458,SELECT * FROM GroupMembers WHERE GroupId = ? AND MemberId = ?
0.001136,SELECT content FROM Attachments WHERE id = ?
0.001132,SELECT content FROM Attachments WHERE id = ?
0.001713,SELECT * FROM Users WHERE id = ?
0.001469,SELECT * FROM Principals WHERE id = ?
0.001798,SELECT * FROM GroupMembers WHERE GroupId = ? AND MemberId = ?
0.001441,SELECT content FROM Attachments WHERE id = ?
0.001131,SELECT content FROM Attachments WHERE id = ?
0.001458,SELECT * FROM GroupMembers WHERE GroupId = ? AND MemberId = ?
0.001445,SELECT content FROM Attachments WHERE id = ?
0.001432,SELECT content FROM Attachments WHERE id = ?
0.00178,SELECT * FROM GroupMembers WHERE GroupId = ? AND MemberId = ?
0.001131,SELECT content FROM Attachments WHERE id = ?
0.001447,SELECT content FROM Attachments WHERE id = ?
0.001455,SELECT * FROM GroupMembers WHERE GroupId = ? AND MemberId = ?
0.001132,SELECT content FROM Attachments WHERE id = ?
0.001131,SELECT content FROM Attachments WHERE id = ?
0.001459,SELECT * FROM GroupMembers WHERE GroupId = ? AND MemberId = ?
0.001127,SELECT content FROM Attachments WHERE id = ?
0.001442,SELECT content FROM Attachments WHERE id = ?
0.00146,SELECT * FROM GroupMembers WHERE GroupId = ? AND MemberId = ?
0.001139,SELECT content FROM Attachments WHERE id = ?
0.001124,SELECT content FROM Attachments WHERE id = ?
0.001459,SELECT * FROM GroupMembers WHERE GroupId = ? AND MemberId = ?
0.001137,SELECT content FROM Attachments WHERE id = ?
0.001446,SELECT content FROM Attachments WHERE id = ?
0.001459,SELECT * FROM GroupMembers WHERE GroupId = ? AND MemberId = ?
0.001134,SELECT content FROM Attachments WHERE id = ?
0.001128,SELECT content FROM Attachments WHERE id = ?
0.001458,SELECT * FROM GroupMembers WHERE GroupId = ? AND MemberId = ?
0.001129,SELECT content FROM Attachments WHERE id = ?
0.001434,SELECT content FROM Attachments WHERE id = ?
0.00146,SELECT * FROM GroupMembers WHERE GroupId = ? AND MemberId = ?
0.001445,SELECT content FROM Attachments WHERE id = ?
0.001125,SELECT content FROM Attachments WHERE id = ?
0.001448,SELECT * FROM GroupMembers WHERE GroupId = ? AND MemberId = ?
0.001136,SELECT content FROM Attachments WHERE id = ?
0.001307,SELECT content FROM Attachments WHERE id = ?
0.001325,SELECT * FROM GroupMembers WHERE GroupId = ? AND MemberId = ?
0.001315,SELECT content FROM Attachments WHERE id = ?
0.002165,SELECT content FROM Attachments WHERE id = ?
0.001782,SELECT * FROM Users WHERE id = ?
0.002196,SELECT * FROM Principals WHERE id = ?
0.001352,SELECT * FROM GroupMembers WHERE GroupId = ? AND MemberId = ?
0.001307,SELECT content FROM Attachments WHERE id = ?
0.001312,SELECT content FROM Attachments WHERE id = ?
0.001327,SELECT * FROM GroupMembers WHERE GroupId = ? AND MemberId = ?
0.001308,SELECT content FROM Attachments WHERE id = ?
0.001314,SELECT content FROM Attachments WHERE id = ?
0.001326,SELECT * FROM GroupMembers WHERE GroupId = ? AND MemberId = ?
0.001313,SELECT content FROM Attachments WHERE id = ?
0.001309,SELECT content FROM Attachments WHERE id = ?
0.001326,SELECT * FROM GroupMembers WHERE GroupId = ? AND MemberId = ?
0.001316,SELECT content FROM Attachments WHERE id = ?
0.00131,SELECT content FROM Attachments WHERE id = ?
0.001819,SELECT * FROM Users WHERE id = ?
0.001613,SELECT * FROM Principals WHERE id = ?
0.001355,SELECT * FROM GroupMembers WHERE GroupId = ? AND MemberId = ?
0.001307,SELECT content FROM Attachments WHERE id = ?
0.001438,SELECT content FROM Attachments WHERE id = ?
0.001461,SELECT * FROM GroupMembers WHERE GroupId = ? AND MemberId = ?
0.001127,SELECT content FROM Attachments WHERE id = ?
0.001135,SELECT content FROM Attachments WHERE id = ?
0.001714,SELECT * FROM Users WHERE id = ?
0.001469,SELECT * FROM Principals WHERE id = ?
0.001487,SELECT * FROM GroupMembers WHERE GroupId = ? AND MemberId = ?
0.00113,SELECT content FROM Attachments WHERE id = ?
0.001443,SELECT content FROM Attachments WHERE id = ?
0.00146,SELECT * FROM GroupMembers WHERE GroupId = ? AND MemberId = ?
0.001442,SELECT content FROM Attachments WHERE id = ?
0.001132,SELECT content FROM Attachments WHERE id = ?
0.001459,SELECT * FROM GroupMembers WHERE GroupId = ? AND MemberId = ?
0.00113,SELECT content FROM Attachments WHERE id = ?
0.001439,SELECT content FROM Attachments WHERE id = ?
0.001462,SELECT * FROM GroupMembers WHERE GroupId = ? AND MemberId = ?
0.001441,SELECT content FROM Attachments WHERE id = ?
0.001134,SELECT content FROM Attachments WHERE id = ?
0.001458,SELECT * FROM GroupMembers WHERE GroupId = ? AND MemberId = ?
0.001445,SELECT content FROM Attachments WHERE id = ?
0.001435,SELECT content FROM Attachments WHERE id = ?
0.001465,SELECT * FROM GroupMembers WHERE GroupId = ? AND MemberId = ?
0.001442,SELECT content FROM Attachments WHERE id = ?
0.001134,SELECT content FROM Attachments WHERE id = ?
0.001449,SELECT * FROM GroupMembers WHERE GroupId = ? AND MemberId = ?
0.001135,SELECT content FROM Attachments WHERE id = ?
0.001134,SELECT content FROM Attachments WHERE id = ?
0.001461,SELECT * FROM GroupMembers WHERE GroupId = ? AND MemberId = ?
0.001132,SELECT content FROM Attachments WHERE id = ?
0.001435,SELECT content FROM Attachments WHERE id = ?
0.002396,SELECT * FROM GroupMembers WHERE GroupId = ? AND MemberId = ?
0.001445,SELECT content FROM Attachments WHERE id = ?
0.001128,SELECT content FROM Attachments WHERE id = ?
0.001717,SELECT * FROM Users WHERE id = ?
0.001475,SELECT * FROM Principals WHERE id = ?
0.001488,SELECT * FROM GroupMembers WHERE GroupId = ? AND MemberId = ?
0.00113,SELECT content FROM Attachments WHERE id = ?
0.001131,SELECT content FROM Attachments WHERE id = ?
0.001459,SELECT * FROM GroupMembers WHERE GroupId = ? AND MemberId = ?
0.001445,SELECT content FROM Attachments WHERE id = ?
0.001129,SELECT content FROM Attachments WHERE id = ?
0.001459,SELECT * FROM GroupMembers WHERE GroupId = ? AND MemberId = ?
0.00144,SELECT content FROM Attachments WHERE id = ?
0.001124,SELECT content FROM Attachments WHERE id = ?
0.001459,SELECT * FROM GroupMembers WHERE GroupId = ? AND MemberId = ?
0.001133,SELECT content FROM Attachments WHERE id = ?
0.001133,SELECT content FROM Attachments WHERE id = ?
0.001459,SELECT * FROM GroupMembers WHERE GroupId = ? AND MemberId = ?
0.001134,SELECT content FROM Attachments WHERE id = ?
0.00207,SELECT content FROM Attachments WHERE id = ?
0.001459,SELECT * FROM GroupMembers WHERE GroupId = ? AND MemberId = ?
0.001136,SELECT content FROM Attachments WHERE id = ?
0.001445,SELECT content FROM Attachments WHERE id = ?
0.001455,SELECT * FROM GroupMembers WHERE GroupId = ? AND MemberId = ?
0.001133,SELECT content FROM Attachments WHERE id = ?
0.001125,SELECT content FROM Attachments WHERE id = ?
0.001458,SELECT * FROM GroupMembers WHERE GroupId = ? AND MemberId = ?
0.001129,SELECT content FROM Attachments WHERE id = ?
0.001439,SELECT content FROM Attachments WHERE id = ?
0.00175,SELECT * FROM GroupMembers WHERE GroupId = ? AND MemberId = ?
0.001132,SELECT content FROM Attachments WHERE id = ?
0.001757,SELECT content FROM Attachments WHERE id = ?
0.001458,SELECT * FROM GroupMembers WHERE GroupId = ? AND MemberId = ?
0.001131,SELECT content FROM Attachments WHERE id = ?
0.001302,SELECT content FROM Attachments WHERE id = ?
0.001614,SELECT * FROM GroupMembers WHERE GroupId = ? AND MemberId = ?
0.001316,SELECT content FROM Attachments WHERE id = ?
0.001309,SELECT content FROM Attachments WHERE id = ?
0.001327,SELECT * FROM GroupMembers WHERE GroupId = ? AND MemberId = ?
0.001313,SELECT content FROM Attachments WHERE id = ?
0.0013,SELECT content FROM Attachments WHERE id = ?
0.001325,SELECT * FROM GroupMembers WHERE GroupId = ? AND MemberId = ?
0.001309,SELECT content FROM Attachments WHERE id = ?
0.001311,SELECT content FROM Attachments WHERE id = ?
0.001325,SELECT * FROM GroupMembers WHERE GroupId = ? AND MemberId = ?
0.001314,SELECT content FROM Attachments WHERE id = ?
0.001305,SELECT content FROM Attachments WHERE id = ?
0.001325,SELECT * FROM GroupMembers WHERE GroupId = ? AND MemberId = ?
0.001311,SELECT content FROM Attachments WHERE id = ?
0.001304,SELECT content FROM Attachments WHERE id = ?
0.001898,SELECT * FROM GroupMembers WHERE GroupId = ? AND MemberId = ?
0.00131,SELECT content FROM Attachments WHERE id = ?
0.001311,SELECT content FROM Attachments WHERE id = ?
0.001318,SELECT * FROM GroupMembers WHERE GroupId = ? AND MemberId = ?
0.001313,SELECT content FROM Attachments WHERE id = ?
0.001594,SELECT content FROM Attachments WHERE id = ?
0.001325,SELECT * FROM GroupMembers WHERE GroupId = ? AND MemberId = ?
0.00131,SELECT content FROM Attachments WHERE id = ?
0.001317,SELECT content FROM Attachments WHERE id = ?
0.001325,SELECT * FROM GroupMembers WHERE GroupId = ? AND MemberId = ?
0.001311,SELECT content FROM Attachments WHERE id = ?
0.001311,SELECT content FROM Attachments WHERE id = ?
0.00133,SELECT * FROM GroupMembers WHERE GroupId = ? AND MemberId = ?
0.001311,SELECT content FROM Attachments WHERE id = ?
0.001303,SELECT content FROM Attachments WHERE id = ?
0.001328,SELECT * FROM GroupMembers WHERE GroupId = ? AND MemberId = ?
0.001312,SELECT content FROM Attachments WHERE id = ?
0.00131,SELECT content FROM Attachments WHERE id = ?
0.0016,SELECT * FROM Users WHERE id = ?
0.001629,SELECT * FROM Principals WHERE id = ?
0.001354,SELECT * FROM GroupMembers WHERE GroupId = ? AND MemberId = ?
0.001598,SELECT content FROM Attachments WHERE id = ?
0.00131,SELECT content FROM Attachments WHERE id = ?
0.001325,SELECT * FROM GroupMembers WHERE GroupId = ? AND MemberId = ?
0.001889,SELECT content FROM Attachments WHERE id = ?
0.001305,SELECT content FROM Attachments WHERE id = ?
0.001326,SELECT * FROM GroupMembers WHERE GroupId = ? AND MemberId = ?
0.001132,SELECT content FROM Attachments WHERE id = ?
0.001444,SELECT content FROM Attachments WHERE id = ?
0.001463,SELECT * FROM GroupMembers WHERE GroupId = ? AND MemberId = ?
0.001447,SELECT content FROM Attachments WHERE id = ?
0.001438,SELECT content FROM Attachments WHERE id = ?
0.001458,SELECT * FROM GroupMembers WHERE GroupId = ? AND MemberId = ?
0.001446,SELECT content FROM Attachments WHERE id = ?
0.001129,SELECT content FROM Attachments WHERE id = ?
0.001457,SELECT * FROM GroupMembers WHERE GroupId = ? AND MemberId = ?
0.001133,SELECT content FROM Attachments WHERE id = ?
0.001125,SELECT content FROM Attachments WHERE id = ?
0.001457,SELECT * FROM GroupMembers WHERE GroupId = ? AND MemberId = ?
0.001442,SELECT content FROM Attachments WHERE id = ?
0.001434,SELECT content FROM Attachments WHERE id = ?
0.001456,SELECT * FROM GroupMembers WHERE GroupId = ? AND MemberId = ?
0.001138,SELECT content FROM Attachments WHERE id = ?
0.001131,SELECT content FROM Attachments WHERE id = ?
0.002079,SELECT * FROM GroupMembers WHERE GroupId = ? AND MemberId = ?
0.001445,SELECT content FROM Attachments WHERE id = ?
0.001433,SELECT content FROM Attachments WHERE id = ?
0.001609,SELECT * FROM GroupMembers WHERE GroupId = ? AND MemberId = ?
0.00131,SELECT content FROM Attachments WHERE id = ?
0.001599,SELECT content FROM Attachments WHERE id = ?
0.001324,SELECT * FROM GroupMembers WHERE GroupId = ? AND MemberId = ?
0.002458,SELECT content FROM Attachments WHERE id = ?
0.001308,SELECT content FROM Attachments WHERE id = ?
0.001611,SELECT * FROM GroupMembers WHERE GroupId = ? AND MemberId = ?
0.00131499999999996,SELECT content FROM Attachments WHERE id = ?
0.001317,SELECT content FROM Attachments WHERE id = ?
0.001612,SELECT * FROM GroupMembers WHERE GroupId = ? AND MemberId = ?
0.001312,SELECT content FROM Attachments WHERE id = ?
0.001312,SELECT content FROM Attachments WHERE id = ?
0.001325,SELECT * FROM GroupMembers WHERE GroupId = ? AND MemberId = ?
0.001313,SELECT content FROM Attachments WHERE id = ?
0.001308,SELECT content FROM Attachments WHERE id = ?
0.001898,SELECT * FROM GroupMembers WHERE GroupId = ? AND MemberId = ?
0.00131,SELECT content FROM Attachments WHERE id = ?
0.001307,SELECT content FROM Attachments WHERE id = ?
0.001612,SELECT * FROM GroupMembers WHERE GroupId = ? AND MemberId = ?
0.001441,SELECT content FROM Attachments WHERE id = ?
0.001445,SELECT content FROM Attachments WHERE id = ?
0.001457,SELECT * FROM GroupMembers WHERE GroupId = ? AND MemberId = ?
0.001448,SELECT content FROM Attachments WHERE id = ?
0.001754,SELECT content FROM Attachments WHERE id = ?
More information about the Rt-devel
mailing list