Re: Out of memory using order by on 19 records!

[Thimble Smith]

On Tue, May 18, 1999 at 03:09:15PM -0700, Shafir wrote:
> Thanks a lot. It worked.
> 
> mysql> create table tmplist (
>     ->   userno int(10) unsigned DEFAULT '0' NOT NULL,
>     ->   ip char(15) DEFAULT '' NOT NULL,
>     ->   listtime timestamp(14),
>     ->   runtime float(10,5) unsigned DEFAULT '0.00000' NOT NULL,
>     ->   KEY listtime (listtime),
>     ->   KEY userno (userno),
>     ->   KEY runtime (runtime)
>     -> );
> Query OK, 0 rows affected (0.00 sec)

You don't need those KEYs, and you might not want them.  With only
19 rows, it obviously doesn't make much difference either way.  But
if you have a lot of rows, then those keys will slow down your
INSERT.  And since you're going to read out the whole table anyway,
it probably won't help to have the KEYs defined.

Someone feel free to correct me if I'm wrong.

Tim