>When I perform a complex query with joins, and a LIMIT, then the result >comes back 'immediately'. However, if I add 'ORDER BY price', then the >query times out. Values in the price column go up to about 60,000,000.
Of course, as soon as I clicked send... Asked the query to EXPLAIN itself, and one of the subtables, which is joined, doesn't have an index. Add an index, and it works... Thanks for your help (:-> -- Pete Clark http://www.hotcosta.com http://www.spanishholidaybookings.com The PHP_mySQL group is dedicated to learn more about the PHP_mySQL web database possibilities through group learning. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/php_mysql/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
