[rt-users] DBIx::SearchBuilder oddity locking database

[Thomas Sibley]

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