In a message dated 3/23/2004 12:47:08 PM Eastern Standard Time, [EMAIL PROTECTED] writes:
> The fact is, they may have done something brilliant with their > system and your 'mileage' might be completely typical while they are > experiencing atypically good results. Just because we are mv doesn't > mean no one else is working at exploiting the efficiencies > of those > other systems. Indexing killed it. That's my vote. Look at all your indexes. Look for indexes that are indexing NULLs. And look for indexes that have huge leaf nodes. Remember that the leaf nodes ARE NOT HASHED. That is, each leaf node is one huge, long, string. *Ducks flying objects when people realize what I just said* So don't make indexes on limited sets, unless you want to drag the system down. Will "Don't drag me down!" Johnson -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
