Peter Zaitsev wrote:
>
> Hello mysql,
>
> I was trying to load very huge (5GB 45mil rows) to the text dump in
> sorted order (according to primary key).
> The problem is mysql somehow does not wants to scan the table by
> primary key to produce sorted output row by row, but prefers to use
> filesort which would take quite a long time in this case:
>
> mysql> explain select * from dominf.domip order by ip desc;
>
Try using limit clause
--
_/ _/ _/_/_/ ----- Rafał Jank [EMAIL PROTECTED] -----
_/ _/ _/ _/ _/ Wirtualna Polska SA http://www.wp.pl
_/_/_/_/ _/_/_/ ul. Uphagena 2, 80-237 Gdansk, tel/fax. (58) 5215625
_/ _/ _/ --------==* http://szukaj.wp.pl *==----------
---------------------------------------------------------------------
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