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 _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com We're hiring! Come hack Perl for Best Practical: http://bestpractical.com/about/jobs.html
