My point is that my application is more like a spell checker -- which would probably be terribly inefficient if implemented via mysql. I suppose a super long query like,
in reply to Re^3: Bid data but need fast response time
in thread Bid data but need fast response time
"Select Code,Instances from Codes where code in ('cdfe','abcd','asdf','qwet',...)"
would be the most efficient query. (I would expect to retrieve 10,000 to 100,000 codes for a typical query.) HOWEVER -- even with indices, this seems more like a "DBM" rather than an RDBM problem.