What I usually do is change my columns to rows and add an additional "qualifier" column to indicate what type of data is in that row. Then you only need one or two indexes, one for the qualifier and one for the data. But you can index an almost unlimited number of "keys". Querying and joins will be a little more difficult from a programming standpoint, but it's very flexible.
Hope that helps.
On Monday, July 14, 2003, at 04:12 PM, Circus ETL wrote:
The documentation states that MyISAM tables can be used with more than 32
keys, but I can't get mysql to accept more than 32.
Also, is it possible (advisable) to build a version of the MyISAM tables
that exceed the 64 key limit? If so, how is this done?
-- Brent Baisley Systems Architect Landover Associates, Inc. Search & Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]