What's the optimal db design choice for my 400 000 entries?

Hi all you mysql gurus, I have 400 000 unique strings where each and every one of these strings are associated with 1 - 50 (appr.) integer values. Now, pretty simple for you guys I guess, but how will I design my database to make a search interface against this data as rapid as possible? My

Re: What's the optimal db design choice for my 400 000 entries?

Tommy Svensson \(InfoGrafix\) [EMAIL PROTECTED] wrote on 06/07/2005 04:49:09 PM: Hi all you mysql gurus, I have 400 000 unique strings where each and every one of these strings are associated with 1 - 50 (appr.) integer values. Now, pretty simple for you guys I guess, but how will I