Hi Ruslan,
I have changed those indexes this morning and will monitor the results
today. I created the second new index as CGM2 to prevent the system
complaining about duplicate keys.
Thanks
Richard
Ruslan Zakirov wrote:
4 seconds is still slow, but better than 100-400.
About your indexes. You can and I really suggest to delete the
following indexes on CGM table:
* DROP INDEX GrouMem ON CachedGroupMembers;
* DROP INDEX group1 ON CachedGroupMembers;
* DROP INDEX member1 ON CachedGroupMembers;
And instead create indexes:
CREATE INDEX CGM1 ON CachedGroupMembers(MemberId, GroupId, Disabled);
CREATE INDEX CGM1 ON CachedGroupMembers(MemberId, ImmediateParentId);
Both will be part of 3.8's schema update.
On Wed, Mar 19, 2008 at 8:35 PM, Richard Ellis <[EMAIL PROTECTED]> wrote:
Hi Ruslan,
You are a genius. Response time for the Query Builder is now back to 4
seconds which is good enough for me :0.
Thanks to all your team for all the efforts to work out what was wrong.
Thanks
Richard
Ruslan Zakirov wrote:
Hey, Rechard, the latest results suggest me that we've saddled this
beast :) at least that what explain says and I hope it's correct.
You can check that query again and it should be fast. Wanna try?
You can use SELECT SQL_NO_CACHE ... to make sure it's reproducible and
is not cache hit.
On Wed, Mar 19, 2008 at 7:22 PM, Richard Ellis <[EMAIL PROTECTED]>
wrote:
Hi Ruslan,
here's the two sets of results.
Thanks
Richard
--
Sun.com <http://www.sun.com> * Richard Ellis *
Technical Developer, .Sun eBusiness
*Sun Microsystems, Inc.*
Phone x(70) 24727/+44-1252-424 727
Fax +44 1252 420410
Email [EMAIL PROTECTED]
sun.com
_______________________________________________
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
