I have about 4,500,000 records and I am trying to do a lookup on one field. The most a result set should be is about 73 records. It now takes about 3 minutes to get a result. Is there anything I can do to speed this up. I am using MySQL and i have the table set to MyISAM. I have the field indexed but I do not believe it is actually addressing it.
Any sugesstions???