[rt-users] Q: How to build a ticket query that uses custom fields

Gilmar Santos Jr gilmarsantosjr at safernet.org.br
Tue Jul 4 11:25:24 EDT 2006

Pau Montero Parés escreveu:
> This is a nice tip! I have a 3.4.1 instalation and everything works
> like a charm except the customfield searches. A CF.{value}='yes' has a
> time to display of 99.041657 sec. I supose that this is a mysql
> problem but I didn't find anything odd.
> ObjectCustomFieldValues has 2057 rows and 5 indexes:
> PRIMARY: id (cardinality 1802)
> TicketCustomFieldValues1: CustomField ObjectId Content (cardinality 1802)
> TicketCustomFieldValues2: CustomField ObjectId (cardinality 1802)
> ObjectCustomFieldValues1: Content (cardinality 901)
> ObjectCustomFieldValues2: CustomField ObjectType ObjectId (cardinality
> 1802)
> Is this an innoDB problem? any suggestions?

Maybe the problem is with the index. Try to remove the
"TicketCustomFieldValues" (they are from previous versions).
Take a look at the wiki.bestpractical.com, there is a topic about
permormance tunning. There are mysql tips, apache tips, etc.

Gilmar Santos Jr

More information about the rt-users mailing list