Re: Maximum of 16 indexes per table

[Seth Price <suppressed>]

I have a table of between 90-100 columns and currently 70k rows. I
don't care how long it takes to enter the data, but I would like to
select it as fast as possible. Each column should be theoretically
queried as much as any other. Right now I am using static MyISAM
tables, which seem good enough for now, but in the future I may have
approx. 3,500k rows, so I am a little more worried about my SELECT
performance then.
~Seth


On Tuesday, February 11, 2003, at 12:54 PM, Peter Grigor wrote:

> ----- Original Message -----
> From: "Seth Price" <suppressed>
> To: <suppressed>
> Sent: Tuesday, February 11, 2003 1:43 PM
> Subject: Re: Maximum of 16 indexes per table
>
>
> > Has the maximum number of keys in a MyISAM table been tested more
> > since
> > this post? Is it possible to get above 64 keys? (I'm going for 90,
> > btw)
> > ~Seth
>
> Dood!!!
>
> 90??? on one table???
>
> Peter
> <^_^>
> ---------------------------------------------
> Peter Grigor
> Hoobly Classified Ads
> http://www.hoobly.com
sql


---------------------------------------------------------------------
Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <suppressed>
To unsubscribe, e-mail <suppressed>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php