tor 2006-06-01 klockan 16:55 +0400 skrev Ruslan Zakirov: > I've investigated more on this problem and found out that this problem > of mysql as couldn't optimize well some queries when it's possible, I > know how to hack a workaround and help RDBMs optimize it, but later... > -EHAVENOTIME
The following seems to help MySQL optimize the query better: alter table ACL add key ACLKTH1 using BTREE (PrincipalType, RightName); /Alexander _______________________________________________ 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