[Rt-devel] Performance Problem

[Tina Schade]

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 "="? 

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