> A lot of table scans do to bitmasked column values. > Such that the above query will not utilize a key.
That statement gave me a cold shiver up my spine. You could try an inverted index or match-cache technique, or denormalization. These type of techniques are very app specific, but can reduce things by a factor of 10 or more. (And it assumes things are properly normalized as a starting point.) None may work for you, though. Who knows. Ug. Tables scans. I don't know if I can sleep tonight. I feel for you. At least I know why you need 30 database servers. That has got to be a sight! I'd love to have such hardware at my disposal! Wow. Have some fun! -steve- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
