Hi Christoph, I would suggest you read up about indexes and how they would assist you in your requirements. Without knowing the exact structure of your tables, it is difficult to judge but it sounds like an index (or indexes), correctly structured, would provide what you need. A good read would be
http://dev.mysql.com/doc/mysql/en/mysql-optimization.html Regards David Logan Database Administrator HP Managed Services 148 Frome Street, Adelaide 5000 Australia +61 8 8408 4273 - Work +61 417 268 665 - Mobile +61 8 8408 4259 - Fax -----Original Message----- From: Christoph Lehmann [mailto:[EMAIL PROTECTED] Sent: Wednesday, 4 May 2005 8:57 AM To: mysql@lists.mysql.com Subject: newbie: how to sort a database without extracting the data Hi I am really new to mysql. I need my database to be sorted according to one field. But since the database with 12000000 records is huge, I don't want to do it using SELECT. What I need is just the stored database being sorted on hard-disk. Is there any way doing this like creating a new database and importing the old one but being sorted? many thanks for your kind help cheers christoph (p.s. I need this for later chunk-wise data-fetch with one chunk being homogenous in regard to one (the sorted) field) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]