[rt-users] Limit recordset returned by search on the application level

Hi, We have a big number of tickets in our RT3 (3.8.2). Sometimes, when users run search query without filters the system freezes because it receives more them million records from the database. Is there a way to set global limit for search recordset like 1000 or so to avoid such situation? Thank

Re: [rt-users] How to avoid a huge dataset returning

I use RT 3.8.2 On Fri, Sep 16, 2011 at 6:02 PM, Kevin Falcone wrote: > On Fri, Sep 16, 2011 at 05:08:24PM +0300, Michael Stepanov wrote: > > Hi, > > > > Our RT3 system is a big and it crashes time to time. Today we found one > > query in the slow queries

Re: [rt-users] Cleaning Attachments

On Fri, Sep 16, 2011 at 5:48 PM, Kevin Falcone wrote: > On Fri, Sep 16, 2011 at 05:12:48PM +0300, Michael Stepanov wrote: > >Our RT3 system has Attachments table with size about 300GB. We'd like > to clean it by removing > >old records with files. The rt-shreder can

[rt-users] How to avoid a huge dataset returning

Hi, Our RT3 system is a big and it crashes time to time. Today we found one query in the slow queries log which killed the system: * # Query_time: 97 Lock_time: 0 Rows_sent: 15906633 Rows_examined: 39069181 SELECT main.* FROM Transactions main WHERE (main.Type = 'Create' OR main.Type = 'Commen

[rt-users] Cleaning Attachments

Hi, Our RT3 system has Attachments table with size about 300GB. We'd like to clean it by removing old records with files. The rt-shreder can do this job properly I guess. But there is no way to specify query criteria there. Even direct delete query is failed. Does somebody can suggest how to clea

[rt-users] RT-3.8.2 doesn't send correct HTML letters

Hi, I'm trying to send HTML emails from RT3. I added to the template the content type header: Content-Type: text/html But without luck. I can see two parts of the email - HTML and text in the ticket message text area but I receive the source of HTML email in my mailbox: Content-type: multi