[Rt-devel] Performance Problem

[Ruslan U. Zakirov]

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