Re: Creating more than 32 keys?

2003-07-15 Thread Brent Baisley
If you have to create that many keys, you may want to consider changing your data structure. You additions and updates to the database would get pretty slow if that many indexes have to be updated. What I usually do is change my columns to rows and add an additional "qualifier" column to indicat

Creating more than 32 keys?

2003-07-14 Thread Circus ETL
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? Tom Sundquist Circus Software, LLC Minneapo