Hi, I have a 76,500,000 rows table with 15 fields. I try to sort this rows on all fields, so I am using select all fields1 group by all fields2 or distinct all fields1 with order by all fields2. After sort, I get 62,000,000 rows.
Then I use Linux unique sort, I dump out 76,500,000 table and using sort -u file1 -o file2. I got 76,000,000 rows. I don't know what is wrong about mysql's group by or distinct. Are there any restricts on group by or distinct like number of fields, or size of table or rows of table? Any help is appreciated. --------------------------------------------------------------------- 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
