[Rt-devel] Performance Problem

[Ruslan U. Zakirov]

Tina Schade wrote:
> Hello,
> 
> Yesterday I searched for the ILIKE in DBIX::SearchBuilder. I found it in 
> SearchBuilder/Handle/Pg.pm. There is in the Method _MakeClauseInsensitive the 
> Operator "=" changed to "ILIKE". I set the Operator to "=" and all in RT does 
> funktion very fast and correct. 
> Where is the catch with the "="? 

Catch is 'case sensetivity' of this operator.
Below I gave you link to DBIx::SB patch which change ILIKE to LOWER.

> 
> Greetings,
> Tina
> 
> Am Montag, 19. April 2004 15:30 schrieben Sie:
> 
>>Tina Schade wrote:
>>
>>>Hello,
>>>
>>>I have an big performace problem. I work with RT 3.0.10, SearchBuilder
>>>0.99 and Postgres 7.3.4.
>>>Every time I logged in RT needs 1 minute minimum to build the page after
>>>login. The part to show my own 10 tickets is ok, but for the part to show
>>>the requested tickets take the longest time. I print out the querys and I
>>>notice that the querys difference is the "=" and the "ILIKE". Here are
>>>the queries:
>>
>>All users expect case insensetive searches.
>>Postgres has ILIKE for this, but it's seams very slow. In current SVN
>>repository DBIx::SB uses LOWER instead.
>>
>>http://svn.bestpractical.com/index.cgi/public/revision/?rev=686
>>
>>
>>
>>[snip]
>>
>>
>>>I don´t understand, why you compare ids with "ILIKE" and not with "="
>>>(CachedGroupMembers_2.MemberId ILIKE Users_3.id, Groups_1.id ILIKE
>>>CachedGroupMembers_2.GroupId).
>>
>>This is limitation of DBIx::SB. It does't use info about field type when
>>constructs case insensetive queries.
>>
>>
>>>Does only I have this problem that it takes such a long time to build a
>>>RT-page? Does I have configure RT in a wrong way that it is so slow?
>>>
>>>This fact, that the pagebuilding takes a long time, isn´t only after
>>>login, it is also when I want to show a ticket and the requestor have
>>>some other tickets. Also to show the tickets history.
>>>
>>>How can I get a better performace?
>>>I also searched for "ILIKE", but I can´t find it in RT or
>>>DBIx::SearchBuilder. Where does the "ILIKE" be generated?
>>
>>First of all, you can try DBIx::SB from SVN repository or wait for new
>>its release.
>>
>>
>>>I would be very happy if someone can help me and say me what I have to
>>>change to get a better output.
>>>
>>>Thanks,
>>>Tina
>>>_______________________________________________
>>>Rt-devel mailing list
>>>Rt-devel at lists.bestpractical.com
>>>http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-devel
> 
>