Ok, I have an idea how to fix that problem Here is new file for testing that will give me more info to find the best way to fixing this. We're really close.
You can run it using: mysql -t -u root -ppassword rt3 <../search_possible_owners.mysql.sql >test.res As a first step to fix it you can create the following index on Groups table: CREATE INDEX RUZ_Groups1 ON Groups(Domain, Type, id); Please, run commands from the attachment twice before indexing and after. Thank you for the feedback. On Wed, Mar 19, 2008 at 11:49 AM, Richard Ellis <[EMAIL PROTECTED]> wrote: > > Hi Ruslan, > > Really appreciate the help on this. I'd love to find out why we are seeing > such odd results: > > 298 ticket owners when their are only 88 active users > 1.5 million rows of data when we only have 9983 ticks as of this morning. > > Really odd > > Thanks > > Richard > > [snip] -- Best regards, Ruslan.
search_possible_owners.mysql.sql
Description: Binary data
_______________________________________________ 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
