Re: Presorting

2001-02-20 Thread Fred van Engen
On Mon, Feb 19, 2001 at 10:22:58PM -0500, Paradox wrote: I have a table with an integer auto increment primary key, INVNUM, and a CHAR(48) field NAME. Is there a way I can have my table presorted by the text field, Yes, in 3.23.33 you can use myisamchk with the -R option. I don't have a

Re: Presorting

2001-02-19 Thread Ed Carp
Paradox ([EMAIL PROTECTED]) writes: I have a table with an integer auto increment primary key, INVNUM, and a CHAR(48) field NAME. Is there a way I can have my table presorted by the text field, so that a select call with "ORDER BY NAME" is just as fast as "ORDER BY INVNUM"? I have tried