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

2011-09-20 Thread Jeff Fearn
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

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

2011-09-20 Thread 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