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

[Gilmar Santos Jr]

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