[table] Is there a significant CPU consumption difference between this:
SELECT * FROM posts ORDER BY lastPostTime, id compared to this: SELECT * FROM posts ORDER BY lastPostTime My gut feeling tells me that they should almost take the same amount of time to execute, because 'id' only needs to be compared if 'lastPostTime' is the same (when comparing two rows to decide which ones go first) --------------------------------------------------------------------- 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
