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 tr