On 12/18/02 9:48 AM, "Qunfeng Dong" <[EMAIL PROTECTED]> wrote:
> But I am indeed seeing > not-so-good performance (join on tables much smaller > than yours takes minutes even using index) and I seem > to read all the docs I could find on the web about how > to optimize but they are not working for me Why don't you just post the table structures and the join query that you have "trouble" with? There are enough expert here on this list who are happy to help you further optimize your database if possible. /h <MySQL, TABLE> --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php