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" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
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 <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
