On 09/20/2011 02:03 AM, Jeff Fearn wrote: > Hi, using RT 4.0.2 and DBIx::SearchBuilder 1.61 (also tested 1.59) I can > reliably create a search using the RT4 GUI that locks up the database. > > It appears that the search used to generate the 'Found X tickets' text > generates a large set of joins which murders MySQL :( > > The query is a simple search with a created-date and 9 > Requestor.EmailAddress' to check. See attached rt-attr.txt. Note that > the dataset the query returns is only 72 tickets.
I bounced this into RT so we don't lose track of it: http://issues.bestpractical.com/Ticket/Display.html?id=18414 Thomas -------- RT Training Sessions (http://bestpractical.com/services/training.html) * Chicago, IL, USA September 26 & 27, 2011 * San Francisco, CA, USA October 18 & 19, 2011 * Washington DC, USA October 31 & November 1, 2011 * Melbourne VIC, Australia November 28 & 29, 2011 * Barcelona, Spain November 28 & 29, 2011
