List:General Discussion« Previous MessageNext Message »
From:Thimble Smith Date:May 18 1999 10:15pm
Subject:Re: Out of memory using order by on 19 records!
View as plain text  
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
Thread
Out of memory using order by on 19 records!Shafir18 May
  • Re: Out of memory using order by on 19 records!Bill Rhodes18 May
    • Re: Out of memory using order by on 19 records!Shafir18 May
  • Re: Out of memory using order by on 19 records!Thimble Smith19 May
    • Re: Out of memory using order by on 19 records!Shafir19 May
      • Re: Out of memory using order by on 19 records!Thimble Smith19 May
        • Re: Out of memory using order by on 19 records!Shafir19 May
          • Re: Out of memory using order by on 19 records!Thimble Smith19 May
  • Out of memory using order by on 19 records!Michael Widenius24 May