Hello. I have a MySQL database with approximately 36,000,000 records loaded into a single MyISAM table. I wouldn’t expect a search of such a large dataset to be instantaneous, but as it stands a simple SELECT query takes around 2 minutes to process. Is there any way to speed this up? I know a fair amount about database topography, but I can’t see a simpler means of storing the data.
A friend suggested loading the entire table into memory, but I doubt Dreamhost would allow such a practice on a shared server. Would switching to InnoDB make a difference? Thank you.