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 > -- Best regards, Ruslan. _______________________________________________ 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