I have a mySQL database with two tables that I am trying to perform a Left Join upon. Table A has approximately 38000 records and Table B has approximately 43000 records. If I do a Inner join on the tables on the ID field it takes less than 1 second to perform the select statement. If I perform a Left Join on the same tables and on the ID fields it takes almost a minute to two minutes on testing. Any suggestion of why this might be happening or a solution. I have tried the LIMIT function that helps but doesn't solve the problem of letting me gather all of the data and then process it. I have performed Left Joins on other tables with Table A with no problem, but a Left Join between A and B it has major time issues. Any suggestions. Thanks Scott
__________________________________________________ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ --------------------------------------------------------------------- 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
